DSXchange

then why do you wanna have upsert???

if the record already exists on a key, do you want to update the record (in the table) with the new one or you want to reject that record???

Are you calling the store procedure in a OPEN/CLOSE command in ODBC Enterprise stage???

CAN YOU BE MORE SPECIFIC??

i am also referring to the same before sql you are talking about in OCI stage...

just mentioned the syntax of using it.

try in OPEN/CLOSE command.

you can mention padchar in the FORMAT tab under TYPEDEFAULTS->GENERAL section...
you should be able to accomodate reading the file with padchar..

can you be more specific..about your files?? what is the problem reading the files using sequentail files??

using this format would solve the issue

repost

using this format would solve the issue

post the complete error

node_node0: Player 1 terminated unexpectedly. main_program: APT_PMsectionLeader(1, node0), player 1 - Unexpected exit status 1. main_program: Step execution finished with status = FAILED. warning --- main_program: Received SIGPIPE signal caused by closing of the socket on port 13,400. No output wil...

repost

repost