![]() |
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| High Level Programming Post questions about C, C++, Java, SQL, and other programming languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Shell/perl script to connect to different servers in single login in teradata | monika | Shell Programming and Scripting | 1 | 10-20-2008 05:26 PM |
| Script that can access any type of(Teradata,Oracle) database | monika | Shell Programming and Scripting | 3 | 07-04-2008 07:42 AM |
| Connectivity b/w Unix and Teradata Utilities | kunal_dixit | SUN Solaris | 2 | 06-24-2008 02:26 PM |
| Enterprise Unix Roundup: The Ghost of Unix Future - Server Watch | iBot | UNIX and Linux RSS News | 0 | 12-19-2007 12:20 PM |
| Running UNIX commands remotely in Windows box from Unix box – avoid entering password | D.kalpana | UNIX for Dummies Questions & Answers | 1 | 04-20-2007 05:24 AM |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
||||
|
Unix - teradata
I am trying execute a sql file from the script and the sql file has the following code snippet, which throws out the error given below
FOR C_FINELINE_LP AS CURSOR C_SLS FOR SELECT * FROM WM_UTIL.FLT_DEP WHERE LOAD_IND = 'N' DO ….. ….. …. END FOR; FOR C_FLTSLS_STR_LP AS CURSOR C_SLS FOR SELECT * FROM WM_UTIL.GB_STORE_INFO WHERE STORE_TYPE = 'X' DO …. …. …. END FOR; Error ------ FOR C_FLTSLS_STR_LP AS CURSOR C_SLS FOR $ *** Failure 3706 Syntax error: expected something between the beginning of the request and the 'FOR' keyword. Statement# 2, Info =5 END FOR; /* END OF FILTER SALES COMPUTATION, STORE LOOP */ $ *** Failure 3707 Syntax error, expected something like a name or a 'TRANSAC TION' keyword or a 'FASTEXPORT' keyword or a 'LOADING' keyword between the 'E ND' keyword and the 'FOR' keyword. Statement# 1, Info =9 END FOR; /* END OF A FINELINE PROCESSING */ $ *** Failure 3707 Syntax error, expected something like a name or a 'TRANSAC TION' keyword or a 'FASTEXPORT' keyword or a 'LOADING' keyword between the 'E ND' keyword and the 'FOR' keyword. Statement# 1, Info =9 *** Warning: EOF on INPUT stream. |
| Bookmarks |
| Tags |
| error, loop, teradata, unix |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|