DSXchange

Hi
You can use the oconv function like this

Hi,
I just want to let you know how I solved this problem.
Last Monday, i opened the Designer and my jobs weren't there.
I opened the last job in the file menu and it worked.
I did a query in the admisnitrator and it worked.
So with the command DS.REINDEX ALL my jobs hopefully came back.

Hi,

Do you try the Complex Flat File,who is designed to treat special file.
In that pluggin you can specify the start and the end row.

Hi
Do you try to write in a CFF stage ?
I don't do it myself but maybe it will transfrom your data to the copybook format.

Hi, I'm sorry for the delay. I changed my job by deleting the link collector and using a pivot stage. The job runs with the time it had in the previous version. I'm just worried about the behavior of Datastage. A minor change shoudn't have a huge impact. I have to change a lot of jobs , because they...

Hi,
My job split rows and use a link collector before writing in a DB2 database.
I'll investigate if others changed where made with this upgrade.

Hi
Since we migrate to the 7.1r2 from the 7.1r1 we have some issues.
We have job that run forerever.
We have job that last 2:44 minutes r1 and now last 47:28 minutes.
Did someone encounter the sames troubles ?

Thanks for Helping

If i do that (''01/01/2007'') db2 looks for a column named 01/01/2007 and it's doesn't work. Anyway, for some reasons the other guys in my team thought that i can't do that in the DB2 API. I test it and it works. In the before tab I have ALTER TABLE DBM02.IFCE_IFC_CD_ECRITURES_COMPTABLE ACTIVATE NOT...

Kumar, I call the delete.cmd in a Before routine. The delete.cmd create a sql file and execute it like that DB2CMD.EXE /w /c DB2.EXE -tvf FicSql -l FicLog The sql file cotains UPDATE COMMAND OPTIONS USING C OFF; CONNECT TO DB1 USER USR1 USING xxxx; ALTER TABLE DBM02.IFCE_IFC_CD_ECRITURES_COMPTABLE A...

Hi, I would like to perform a huge delete inside Datastage. I have to handle the log of the database. I know the db2 command and it's works with a call to a .cmd file. I have some issue with the ' caractere who disappear between datastage and my cmd.(ex Date_1='01/01/2007' in datastage become Date_1...

Hi Sorry for being so long but I had some issue with my account. When I rewrote the job I use your files (no_header.txt and header.txt) and in the header.text I have 1 header and 33 Bodies. The selection criteria tab is set with (for the header link) Start Record=0 and End record=0 ID Fields=Rec_Typ...

Hi Sorry for the miscue. I just want to check the value of this fields. For the body it's Start=2 End=9999999999999999999 (to be sure to proceed all the rows). I just download your job, rewrite it and i have one header and 33 bodies in my results files. By the way you can do the same thing with one ...

Hi Sorry for the miscue. I just want to check the value of this fields. For the body it's Start=2 End=9999999999999999999 (to be sure to proceed all the rows). I just download your job, rewrite it and i have one header and 33 bodies in my results file. By the way you can do the same thing with one l...

Hi,
Do you set the Start/End Record fields in the selection Criteria tab.
Start=1 End=1 for the header
Start=2 End=0 for the Body.

How can i validate my compile if the import works on the pre-prod server and not on the production one ?

Maybe something is wrong on the production server ?
I forgot to mention that the project is protected.