Recent content by jliang

I use the following command: bteq .logon username, password < sql.scp > sql.log. In the sql.scp, you call the store procedure Hope it works for you

Hi, I created store procedure under V2R41 with volatile table. It works very well, but after we upgrade the server to V2R512, I got problem when I compile it. the code likes: create volatile table test, NO LOG ( column1 char(10) not null ) unique primary index (div_line) on commit...

Hi, I have a store procedure to pass a string as parameter, when the string length is less than 100, the SP runs fine, when I pass the string longer than 230, I got error code: 3706. When I catch the SQL and run on queryman, it works fine. Can anyone tell me is there any limit size for a...

Hi, I try to use substring to pad '0' to the decimal data, I got error 3996 --" Right truncation of string data ". I think the problem is that there are some 0.00 format data. I have another column without zero data, it works fine. substring('0000000000' from char_length(trim(cast(nms as...

It works now. Thanks very much Jing

You can use .quit errorcode to get errorcode in the log file

Hi, I try to create a volatile or temp table, but I need pass parameter to the create table statement. I want to know if Teradata allow to do the following statement in the Store Procedure: Create volatile table test, NO LOG (col1 varchar(10) :str1 :str2 ,col2 decimal(10,2) ) primary...

Hi, Does Teradata has function to count how many rows were deleted after I deleted several rows using delete statement? Thanks very much in advance. Jing

Hi, I am new for perl. I wrote a perl script to replace the variables in a file. But I got error message: out of memory during "large" request for 67112960 bytes, total sbrk() is 5152738 8 bytes at ../autobackend/bin/backend.plx line 30, <READ_FSTLD_FILE> line 1. I do not understand this...

Can I do same way for fastexport? such as .export outfile test.txt mode record format vartext " "; Thanks very much. Jing

Hi, ED, It works fine. Thanks very much Jing

Hi, I write a Korn shell script to use LET command to calculate how many processes are running. the syntax is: LET "activejob='ps -ef|grep 'test.sh'|wc -l '" but I got syntax error. Can you help me with this problem? Many thanks in advance. Jing

Hi, I need load the flat file with TAB delimiter to Teradata using Fastload. Does anyone can tell me the syntax for this? Thanks very much in advance. J

Hi, Dieter, I changed the collect stats statement with temporary. Now the T5343 error is gone. but I still get 52010 error. I DO create temporary table outside the SP, but in the SP, I still have create temp table statement and insert data to this temp table. I think maybe the create temporary...

The SP ran out of spool space during insert into table2. I found out the insert SQL has outer join and count(distinct), both skew and spool space and ran out of spool space for one AMP. I modify the SQL to create subquery, and now it works fine. I also follow your insturction to collect...