#DateForumTypeThreadPost
15806 Aug 2016 @ 03:15 PDTDatabaseReplyTeredata Error 5497: CALL cannot be submitted in multi-statement requestThanks Fred for your response. So Can't we do it the way I am trying to do? Macros can have more than one SQL statement but can't we add a SP call with the SQL or any other statement in the macro?
15705 Aug 2016 @ 02:50 PDTDatabaseTopicTeredata Error 5497: CALL cannot be submitted in multi-statement requestHi, I have a macro in which I have two statements. One is the SP call and the other one is a SELECT statement. The body of both SP and macro is given below: REPLACE PROCEDURE WAQ.DATA_VALIDATIO...
15618 Jul 2016 @ 05:10 PDTDatabaseReplyCalculate column value based on previous computed valueThanks a lot, this is what I was looking for.
15513 Jul 2016 @ 12:24 PDTDatabaseReplyCalculate column value based on previous computed valueHi Sachin, Thanks for you response. Can we do the same without using CSUM as it is a deprecated function. Also in the output report, I want to display the previous row TOTAL value in the FRU colu...
15410 Jul 2016 @ 11:29 PDTDatabaseReplyCalculate column value based on previous computed valueHere are DDL's and DML's for the above example: drop table test; create volatile table test ( org varchar(5) ,dest varchar(5) ,FRU integer , VEG integer ) on commit preserve...
15310 Jul 2016 @ 11:28 PDTDatabaseTopicCalculate column value based on previous computed valueHi, I have a requirement to make a derived column called TOTAL which is calculated by subtracting FRU from VEG column (based on grouping of org and dest) and then for every next row calculate the...
15221 Jan 2016 @ 02:29 PSTConnectivityTopicConnect Teradata SQLA using LDAPHi, I have installed OpenLdap for windows and now I am trying to use LDAP to connect SQL Assistant. I am looking for some help/guide which tell me how to create a DSN connection for using LDAP an...
15112 Jan 2016 @ 03:15 PSTToolsReplyIssue with importing CLOB data using BTEQThanks a lot Fred. The code you provided is working as expected. Thanks and Regards.
15011 Jan 2016 @ 02:23 PSTToolsTopicIssue with importing CLOB data using BTEQHi, I have a simple BTEQ script (given below) to load CLOB data in an empty table. .LOGON ; DELETE FROM TTE ALL; .IMPORT INDICDATA FILE = C:\TEST\Data_Clob; USING (LOBTYPE CLOB(1000000000...
14911 Jan 2016 @ 02:18 PSTDatabaseReplyBTEQ Export truncating CLOB column valueHi Fred, okay. Or we can put the result in a table in SP and then export the result from that table in BTEQ.
14808 Jan 2016 @ 02:47 PSTDatabaseReplyBTEQ Export truncating CLOB column valueHi Fred, thanks for your response. Yes you are right, I have removed .SET INDICDATA OFF and SET WIDTH from the code and its working fine. The code is given below: .LOGON .SET LARGEDATAMODE O...
14707 Jan 2016 @ 03:31 PSTDatabaseReplyBTEQ Export truncating CLOB column valueHi Fred, Thanks for your response. I was going through the documentation (link given below) and its section "Exporting Large Data Objects in Deferred Mode" says that deferred mode transf...
14606 Jan 2016 @ 02:21 PSTDatabaseReplyBTEQ Export truncating CLOB column valueI have also tried using DEFERTRANS option but still no luck. BTEQ is not exporting more than 64k data. Below is the updated code: .LOGON ; .SET LARGEDATAMODE ON; .EXPORT INDICDATA DEFERTRANS...
14505 Jan 2016 @ 03:55 PSTDatabaseTopicBTEQ Export truncating CLOB column valueHi, I have a simple stored procedure which returns CLOB value. I am calling the procedure from BTEQ and then exporting that value in a file. Now the problem is that BTEQ is truncating the value f...
14421 Dec 2015 @ 11:49 PSTDatabaseReplyUsing variable in Teradata SIGNALThanks a lot Fred for your help. I'll report these two issues to Teradata team.
14317 Dec 2015 @ 09:09 PSTDatabaseReplyUsing variable in Teradata SIGNALHi Fred, You are right because I have an INSERT statement in the handler of L2 and I changed the code in L2 as given below: REPLACE PROCEDURE WAQ.TEST_L2(P_DEPT_NAME VARCHAR(30)) BEGIN DECLA...
14216 Dec 2015 @ 09:05 PSTDatabaseReplyUsing variable in Teradata SIGNALHi Fred, I can not move all the code from main SP handler to TEST_L2 hanlder because certain logging needs to be done in main SP. But still for testing it, I changed the code and made the followin...
14116 Dec 2015 @ 02:04 PSTDatabaseReplyUsing variable in Teradata SIGNALHi Fred, Sorry I didn't get what you mean by "move the logging into the handler block in TEST_L2". Can you explain a bit so that I can try that. Moreover, L2 will always have its ha...
14015 Dec 2015 @ 01:44 PSTDatabaseReplyUsing variable in Teradata SIGNALHi Fred, Following is the code: REPLACE PROCEDURE MAIN(P_DEPT_NAME VARCHAR(30)) BEGIN DECLARE vError_Text VARCHAR(256); DECLARE vError_Msg VARCHAR(256); DECLARE vSQL_State VARCHAR(6)...
13910 Dec 2015 @ 09:01 PSTDatabaseReplyUsing variable in Teradata SIGNALHi Fred, L1 is calling L2 and L2 is calling MAIIN. All these SPs have handlers. Yes you are correct, I am calling SIGNAL from MAIN SP with my custom SQLSTATE and message. Now the handler in main ...
13810 Dec 2015 @ 03:20 PSTDatabaseReplyUsing variable in Teradata SIGNALCan someone please help me in resolving the issue.
13708 Dec 2015 @ 12:03 PSTDatabaseReplyUsing variable in Teradata SIGNALHi Fred, thanks for your response. Actually I have a scenario where I have a set of custom SQLSTATEs (around 50) with messages which I want to raise based on certain conditions in Teradata SPs. No...
13607 Dec 2015 @ 03:27 PSTDatabaseReplyUsing variable in Teradata SIGNALOkay then that means that we can not SIGNAL/RESIGNAL the SQLSTATE dynamically from the caller procedure and the only way is to hardcode the SQL code in SIGNAL/RESIGNAL?
13503 Dec 2015 @ 09:22 PSTDatabaseTopicPassing on SQLSTATE using SIGNAL to caller SP using Hi, I have scenerio where I am raising a custom exception using SIGNAL statement in SP named TEST_DEPT. The SIGNAL statement is given below: SIGNAL SQLSTATE 'U0123' SET MESSAGE_TEXT = &...
13403 Dec 2015 @ 01:24 PSTDatabaseReplyUsing variable in Teradata SIGNALHi MaximeV, Yes we are using handler but my question is that is there any way we can use the variable in SIGNAL statement?

Pages