#DateForumTypeThreadPost
1903 Feb 2014 @ 01:22 PSTDatabaseReplyCLIv2 program and TimeStampI am writing external stored procedure which can execute dynamic call statement. Call statement can have out parameters. The only problem I see is with Timestamp and Time, when DBCAREA specifies th...
1802 Feb 2014 @ 03:23 PSTDatabaseReplyCLIv2 program and TimeStampI found one way to determine whether column is CHAR or TimeStamp/Time. One need to use Format: tmp = (PrepInfo_t *)(dbcarea_pt->fet_data_ptr); for (i = 0; i < 100; i++)     ...
1702 Feb 2014 @ 12:27 PSTDatabaseTopicCLIv2 program and TimeStampHi all, I am writing CLIv2 program (acutally this will be external procedure later) and have following question. When issuing following query "SELECT current_timestamp(0)" in the program...
1624 Sep 2012 @ 11:15 PDTGeneralTopicMeaningful errors from external stored procedureHi guys, Is there a way to return meaningful error codes working with external stored procedure? Detailed description: When error occurs in external stored procedure then the value of SQLCode be...
1523 May 2012 @ 11:48 PDTDatabaseReplyRetrieving Data based on a hashrow generated value Hi Vinay, Please specify such examples which can be recreated without making any changes to them. Basicaly, it is bad idea to generate IDs using hashrow because of the synonims. Answer t...
1421 May 2012 @ 03:33 PDTDatabaseTopicDBQLStepTbl Hi all! Could you please explain me what does CPUTime column of DBQLStepTbl table mean? I have Teradata Express (2 AMPs) and for one of the rows in the table MAXAmpCpu + MINAmpCpu > CPUTi...
1316 May 2012 @ 06:17 PDTDatabaseReplyDropping Secondary Indexes and referential integrities Why don't you want to write recursive query to make comma list of the fields you need? Or you can create NAMED indexes to specify only index name and table name: drop index MyIndex on My...
1216 May 2012 @ 02:24 PDTDatabaseReplyHow to use fetch in a dynamic cursor Thanks, Dieter, it worked for LANGUAGE SUPPORT MODE    Standard RELEASE    13.00.01.13 VERSION    13.00.01.13     By ...
1115 May 2012 @ 07:00 PDTDatabaseReplyHow to use fetch in a dynamic cursor RELEASE    13.00.00.12 VERSION    13.00.00.12 LANGUAGE SUPPORT MODE    Standard   TD express
1015 May 2012 @ 05:59 PDTDatabaseReplyHow to use fetch in a dynamic cursor Dear Dieter, can you compile your procedure: CREATE PROCEDURE GetEmployeeSalary (IN EmpName VARCHAR(100), OUT Salary DEC(10,2)) BEGIN DECLARE SqlStr VARCHAR(1000); DECLARE C1 CUR...
901 May 2012 @ 03:39 PDTDatabaseReplyTab and new line symbols Thanks, but I was asking about following: Select '$' || x'0A' || '$';
830 Apr 2012 @ 11:45 PDTDatabaseReplyCalling multiple stored procedures from stored procedure I run following script:   DATABASE SAMPLES; CREATE TABLE master(x VARCHAR(20)); REPLACE PROCEDURE master_proc() BEGIN FOR rec AS Cur CURSOR FOR SELECT x FROM master DO EXECUTE ...
730 Apr 2012 @ 02:57 PDTDatabaseTopicTab and new line symbols Hi all, How can I add Tab and new line symbol to a string without using UDF?   Thanks.  
630 Apr 2012 @ 02:54 PDTDatabaseReplyCalling multiple stored procedures from stored procedure From where do you create procedure?
524 Apr 2012 @ 02:48 PDTGeneralReplyExternal stored procedure to run SP. Strange BUG! I solved this task using CLI procedures (instead of using FNC_CallSP).
422 Apr 2012 @ 12:47 PDTDatabaseReplySql help. select mT.*, max(case when calendar_date = dt then week_of_year end) over(partition by Dt) from ( select calendar_date, week_of_year, max(case when day_of_week = 2 then calendar_date end) ove...
321 Apr 2012 @ 04:18 PDTGeneralReplyExternal stored procedure to run SP. Strange BUG! And want to add that if the length of SP's name is 29 (not 30) execution completes.
221 Apr 2012 @ 04:14 PDTGeneralReplyExternal stored procedure to run SP. Strange BUG! RELEASE    13.00.00.12 VERSION    13.00.00.12 LANGUAGE SUPPORT MODE    Standard  
121 Apr 2012 @ 04:08 PDTGeneralTopicExternal stored procedure to run SP. Strange BUG! Hi guys! I want to create XSP to dynamicaly call existing SP by name. I've read manuals and came to the following solution: /*REPLACE PROCEDURE TestProc(ProcName Varchar(30)) LANGUAG...