DSXchange

DSguru2B,
The database is not generating the unique index.
The columns in it are datas like client number and creation date.

Thanks for replying,

Hi All I am inserting rows in table with the DB2/UDB api stage. The transaction size is set to 10000. If my job abort after the 32458 row, the first 32000 are in the database (due to the commit each 10000 rows). I can't clear the table before restarting the job. The way i found to protect myself is ...

Hi
You have to do your ftp in binary mode.

Hi,

Does anyone interested by a new version of the SwitchEBCDICSign routine ?

Hi
Ray is (as always) right, check the CFF documentation, there is an example inside explaining how to handle the "double" occurs.

Ray,
I can't read the end of you message.
The reason of the sequencer restriction is that we want to write log outside the director and produce restart point .
We do this by using routine and job control.

Hi All

Maybe the cvs is not conform, for example if the last columns never had value the last ; may be missing.

I had this problem last month.

Chulett,

I don't think my solution is overly complicate i wrote it because in my projects sequencer are forbidden so i have to work with job control and Before/After Routine.

Your reply make me ask this :
Is $INCLUDE UNIVERSE.INCLUDE ODBC.H not ship with DS ?

Thanks

ketanshah123, I would do your actions in a job control. Try to connect to your database with this example of code: status = SQLAllocEnv(hEnv) status = SQLAllocConnect(hEnv, hConn) status = SQLConnect(hConn, DSN,USER,PWD) IF status =SQL.ERROR THEN call DSLogWarn("Database KO","TRACE&qu...

Hi, To fill my needs more precisely I wrote my own version of the SwitchEBCDICSign. Function SwitchEBCDICSign(Montant) LMontant=Trim(Montant) Longeur=len(LMontant) Lien=LMontant[1,Longeur-1] Car=SEQ(Right(LMontant,1)) if num(LMontant) then Ans=LMontant else * Call DSLogInfo("Montant ":LMon...

Stiwari

Do you check the format of the column?
Maybe you lose some 0 in numeric column.

Hope this help.

WoMawill

Your function is great but can you be more explicit about its use.
Do you call it everytime ?
Is the null return an error or a no action needed flag.

Thank you.

Anu, If you have a copybook,just import it in DS (without the comments) and load it in a CFF stage. The redefine columns will appear like regular ones. You have to pay attention if the redefine is include in a occurs. In that case the redefine column is set to the column of the first occurs. You can...

Hi,
Like Chulett said the comments realy confuse the CFF stage.
It's better to delete then.
I had some troubles with redefine in occurs too.
The redefines column was set to the first occurs.