DSXchange

Hi,

Is there a way to find a folder name given the job name. I have list of jobs, I want to find in which folder (Datastage designer), they reside?

Thanks

Thanks James. It worked! :D

Hi, When does an error like this occur. APT_CombinedOperatorController(0),0: Field 'ColName' from input dataset '0' is NULL. I have the following condition in a Timestamp field of Transformer. If ColName='00000000' Or StripWhiteSpace(ColName)='' Then '' Else StringToTimestamp(ColName,"%yyyy%mm%...

If nothing of that is working, u can also do this

Neednt pass anything. Leave it as default

Thats right!

JobStartTS should be JobStarted
And JobEndTS should be JobEnd

Hope you got it Kiran

I guess the log would say why the records got rejected. What is the warning shown there?

Here is the after job routine that would display job name, job start timestamp and job end timestamp in log $INCLUDE DSINCLUDE JOBCONTROL.H JobHandle = DSJ.ME JobName = DSGetJobInfo(JobHandle,DSJ.JOBNAME) JobStarted = convert(" :-","_",DSGetJobInfo(JobHandle,DSJ.JOBSTARTTIMESTAMP...

Do a view of this sequential file in Seq File Stage. Are these values getting read as NULL or Blanks.

What is the condistion you have given in Transformer.

Can you post your code here.

One another option is File Pattern.

You can choose "Read Method" property to "File Pattern" and File name as "*_Sample_File"

But this can be used if any specific pattern there in file.

Try this.
StageVar:
If StripWhiteSpace(NullToEmpty(Input Col))<>'' Then If IsNotNull(Input Col) Then 0 Else 0 Else InputCol

Reject in Transformer where StageVar=0

Hope this works!

You can give suppress_zero after conversion. This would result in 11302.06.

If you want to ginore only zero's in mantissa, then convert it to varchar again and trim zero's on the left.

Hope this helps!

Take the count of Field 3 in reference link and put it in one column, say A1.

In Transformer, extract srcA[1,A1] - extract the required substring and then do a lookup again to do comparsion.

Hope this works

What is the value in the column?
Did you manually type the table definition?
If so, do it using import table definition for both source and target.
This might solve

This can be done in after job routines. You can use DSGetLogSummary and connect to database to add entry in DB2 tables.