DSXchange

Save your job under another name, delete the original job, rename your copy back to the original name and recompile & run. This will be much faster and safer than trying to attempt to identify the logfile problem and fix it.

In which program are you seeing this error?

StringToTimestamp(In.Col,"%yyyy/%mm/%dd %HH:%nn:%ss %aa")

For test purposes, replace your with

EXECUTE 'SH -C "':commande:'"' CAPTURING result RETURNING SystemReturnCode
PRINT 'Result returns "':CONVERT(@FM,'<cr>',result):'"'.

Yes, I did - I can't recall the volumes, but it was on a big AIX box with a fast SAN and I went up to a lot of Mb. I think I made the sizes such that the jobs ran at least 10 minutes so I could get a good signal-to-noise ratio and consistent results.

Did debugging parallel jobs get implemented at 8.5 or at 8.7?

A couple of years ago I did some comparitive testing for performance differences between lookup filesets and datasets and found that both performed with almost the same speed. Since lookup fileset were (and remain) black-boxes with no facility to view the data I chose to stick with using datasets ev...

There is nothing broken here, in my opinion.

Since DSAttachJob returns an invalid handle, the call to DSGetJobInfo() will return the error code "DSJE.BADHANDLE"

..If (IsNull(column1) or TrimF(TrimB(column1))='') Then '****' Else TrimF(TrimB(Convert('"','',column1)))... An "OR" condition will evaluate all elements, thus if column1 were to be nullable the statement above would not work. But since "column1" is a stage variable it cann...

How about: $INCLUDE DSINCLUDE JOBCONTROL.H EQUATE Comma TO "," JobList = DSGetProjectInfo(DSJ.JOBLIST) JobCount = DCOUNT(JobList,Comma) ThisJob = DSGetJobInfo(DSJ.ME,DSJ.JOBNAME) FOR I = 1 TO JobCount JobName = FIELD(JobList,Comma,I) IF ( JobName <> ThisJob ) THEN JobHandle = DSAttachJob(J...

Piece of cake with RCP. 1. Declare your source table to use the parameterised SELECT statement (you don't need to pass in the datatypes of the columns that you are selecting) 2. Do not define ANY column in the output link to this stage, just activate RCP in the tick box. 3. Make this link to go a da...

I don't know if that is possible. The Server job pallette contains conversion routines to COMP-3; so that might be an option.

Think of those Vnnn numbers as surrogate keys to other job components

That really does sound like a strange problem indeed. Can you make a test job, copied from you original one where you do an inner join instead of CDC stage and just output a peek stage. This would let you see if DataStage actually sees the 2 keys as being identical for this set of records - for inst...

I didn't look at the input file in detail and didn't notice that the days and months can be one digit.