|
View previous topic :: View next topic
|
| Author |
Message |
jaspal
New User
Joined: 22 May 2007
Posts: 68
Location: mumbai
|
|
|
|
Hi ,
i want to know what does teh syntax below means i.e order by 1
| Code: |
EXEC SQL
DECLARE Z1 CURSOR WITH HOLD FOR
SELECT I_ACCT
,C_TYP_REQ
,C_AUCTN_HSE
FROM Z.ZCTTTLQ
WHERE I_ACCT = :TEMP-ACCT
AND NOT C_TYP_REQ = 'P'
ORDER BY 1
END-EXEC |
Thanks,
Jaspal
Edited: Please use BBcode when You post some code/error, that's rather readable, Thanks... Anuj |
|
| Back to top |
|
 |
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA
|
|
|
|
| Click on IBM Manuals at the top of the screen and look at the DB2 SQL Reference Manual. |
|
| Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004
Posts: 551
Location: Bangalore
|
|
|
|
| It means order by first col ... which is I_ACCT |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
| Back to top |
|
|
|
|
