| WHEN clause - urgent [message #72040] |
Wed, 26 February 2003 03:30  |
string
Messages: 1
Registered: February 2003
|
Junior Member |
|
|
Hi ! I'm interested in loading certain records in a fixed length input file, I know that it is possible to do that with a statement like :
INTO TABLE SIEBEL.EIM_FN_CONTACT1 WHEN (1:1)= 'D'
but I would like to specify more conditions using a "OR" instead of "AND" How can I do that ? I tried writing:
INTO TABLE SIEBEL.EIM_FN_CONTACT1 WHEN (1:1) = 'D' AND (2:2)='E' OR (2:2) = 'F' OR (2:2) = 'G'
this statement gives syntax errors. Can anyone help me please ?
|
|
|
|
|
|
|
|
| Re: WHEN clause - urgent [message #72065 is a reply to message #72040] |
Fri, 28 February 2003 13:46  |
Michel Bartov
Messages: 35
Registered: February 2003
|
Member |
|
|
Suggestion:
Try use:
INTO TABLE SIEBEL.EIM_FN_CONTACT1 WHEN (1:1) = 'D' AND (2:2)='E'
INTO TABLE SIEBEL.EIM_FN_CONTACT1 WHEN (1:1) = 'D' AND (2:2)='F'
INTO TABLE SIEBEL.EIM_FN_CONTACT1 WHEN (1:1) = 'D' AND (2:2)='G'
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
