DSXchange

I would use the TO_DATE function personally, but if you can't you will have to use Iconv and Oconv:

If you are not fussed about sequential surrogate keys try using @OUTROWNUM.

If you are fussed about sequential surrogate keys just store the MAX_ID in a hashed file for each table and then use @INROWNUM/@OUTROWNUM to add to the MAX_ID.

Try copying the job and then deleting the stage from the newly copied job. If that doesn't work try re-creating the job as it might have corrupted.

Are your jobs in that project sorted into categories? The more jobs in a category, the longer the refresh takes. Moving jobs into a category does not alter the jobs in any way.

Not sure about the refresh rate being able to be higher than 65 secs.

Have a 'Reject' Sequential File stage out of the transformer stage directly before the SQL Server Bulk Loader stage. In your transformer contraints make sure 'Reject Row' is ticked for the 'Rejects' link. Define 5 columns in the rejects file and capture the Link Variables (Output) DBMSCODE, LASTERR,...

When viewing the value in the DB2 client the value is: '3.29999995231628'

and then when viewing through datastage it becomes '3.299999952' ?

Try 'Double' as the SQL Type or 'Float' with a Precision value of 14 or greater if required (I believe you can go up to a precision of 308).

This could be due to Operating System restrictions. What OS is on the server? Is Datastage on the same server as DB2?

Thanks Kim. If the client is happy with this approach and I piece the bits all together I'll add the code into this discussion.

Kim, have downloaded the zip file and it looks interesting but I am using 5.2 where I am on-site currently so therefore can't import the DSX file. Hopefully the client will eventually move to 7.5 and then can implement this type of performance statistics.

Anything I can use for 5.2?

Thanks Ray.

So potentially (in V7.x) if you could get the LinkRowCount (From one stage to the next), DSJ.STAGESTARTTIMESTAMP & DSJ.STAGEENDTIMESTAMP you would be able to calculate the row/sec statistic that appears in the DS Clients?

I am wondering if it's possible to obtain the performance statistics (rows per sec) from all links of a job using DSLinkInfo. I have read through the DS Documentation and can't seem to find a LinkStartTime and LinkEndTime variables that would be used to calculate the performance. You can view the pe...

Looks like I'll be parking it on disk then!

Thanks Ray.

I have a job that generates a value in a transformer stage. I need to pass that value to an after-job subroutine. The routine takes a pipe '|' delimited string, parses it and runs another routine that updates a flat file and performs some other tasks.

What is a neat way to accomplish this?

You might want to have a look at the following code. Originally this design came to me on a Datastage BASIC course that Ray Wurlod took (Thanks Ray :lol: ): ************************************** * Run Job: PocketSportsMasterControl * ************************************** * Run Job if in runnable s...

OK, Craig wins