Search results for query: *

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 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...

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, When I run my store procedure to create temporary table and insert data to this table. I got error T2646. I check the spool space and perm space, both are fine. I do not understand why this problem happened. Can you help me with this issue? Thanks very much in advance. J

Hi, When I create tables (perm tables and global temporary tables) in the store procedure and try to insert data to this table, sometimes, I got error 52010. But when I explain the SQL, there is no error. I do not understand why this error is happened for some create table and insert into...

Hi, Does Teradata have function to get the week number without join calendar table? such as, day of '2004-08-02' is the week 31. Thanks very much Jing

Hi, I have table1, which has a col1 with timestamp(1) data type, and I create another table, tbl2 with a col has same data type timestamp(1). I try to insert data from table1 to tbl2, but I got error message 5407. the insert statement like: insert into tbl2 select col1 as col from table1...

Hi, I need write a sql like: select case when a.col1 in (select col1 from table2) then 'ok' else 'fail' end from table2 b Can I pass a derived table in this statement? Many thanks in advance Jing

Hi, I wrote a store procedure and I need pass a parameter like: '('A,'B','C','D')' as a string to SP. Can you help me how can I work around for it? Thanks very much Jing

Hi, I need pad the '000' to the char field, such as col char(10), and the data only has 5 digits, I need pad 5 '0' at begin of the string, like '0000012345'. Can you help me with it? Thanks Jing

Hi, I know the default date format in store procedure is 'yy/mm/dd', how can I change it to the format 'yyyy-mm-dd' in teradata store procedure? Thanks very much Jing