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. Anyone can help me ?=)