DSXchange

Please post the logic written for all columns inside the transformer

Check the field L_In.ConvDate1 for any special characters like * or blanks.

Hi All,

I want to know the values being passed to the stored procedure triggered using stored procedure stage in a parallel job. The job is currently running in production. Please let me know how to know what values are being passed as arguments to that procedure.

Thanks in advance.

I believe the order of the columns in the sequential file stage and the order of the columns in the file are incorrect. That might be the case. Plz check.

Better use Oracle Connector stage to handle large volumes of data. It is 20% faster than OCI stage.

With Oracle OCI, you can: Generate your SQL statement. Use a file name to contain your SQL statement. Clear a table before loading by using a TRUNCATE statement. (Clear table) Select how often to commit rows to the database. (Transaction size) Input multiple rows of data in one call to the database...

Go to /tmp/ folder in your unix server box. Try searching for a file starting with Capture*. ls -l Capture* It will list some file whose names starting with Capture* Try the same command again and again for multiple times. If any of the file size is getting increased, forcibly delete the file. Other...

Try using 'Force Compile' option.

Is this the same machine you are connecting to datastage designer?

If you are using a new/different machine other than earlier one, try adding the host entry of datastager server in your machine's drivers/etc/hosts file and try..

Hi ray, This is the code snippet used to get the jobinfo in my routine. cmd$DSENV = "cd '":p_DSHOME_DIR:"'":char(10) ; cmd$DSENV := ". ./dsenv":char(10) ; reconJob$Status = cmd$DSENV reconJob$Status := "dsjob -file '":EV_SCRIPTS_DIR:"'/'":DS_ENV_INFO...

Yes. I have placed many DSLogInfo command after each step in my routine.

This problem is occurring when -file switch is used to retrive the domain, server, user, password from a file.

Any help plz..

Yes. I am sorry. I am using -jobinfo to get the status of the job. dsjob command is not resulting any status and getting hanged.

Hi, I have used dsjob command to trigger the job in my server routine. First of all I am checking the whether the job is in compiled/finished/aborted status using dsjob -jobstatus command. If the job is in aborted state, i am going to reset the job. But my problem is the dsjob -jobstatus which i hav...

Hi All, I have added the below code snippets in my routine code before the dsjob call: cmd$DSENV = "cd '":p_DSHOME_DIR:"'":char(10) ; cmd$DSENV := ". ./dsenv":char(10) ; Then to the above statements the actual dsjob command will be appended as below: outputJob$Trigger =...

yes It worked... :D Thanks a ton chulett!!!