DSXchange

Hi,

In Sequencer Jobs, If trigger condition is "Unconditional" and if the job gets aborted, will it fires the Target stage or not.

Hi,

I have to use a query in DB2 stage SELECT * FROM TABLE_NAME WHERE DATE <= "Current timestamp"

Can any one tells me about the MetaSQL function which can be used for CurrentTimestamp.

%CurrentDateTimeIn() == is the right function or not?

Kindly help me

OpenSeq <FileName> To objFileVar Else Create objFileVar Else ErrorCode = 1 WeofSeq objFileVar End End WeofSeq objFileVar CloseSeq objFileVar I found the above lines in one routine and i didn't understand the 100% functionality. Could any one explain me about the code in detail to me? Like the funct...

OpenSeq <FileName> To objFileVar Else Create objFileVar Else ErrorCode = 1 WeofSeq objFileVar End End WeofSeq objFileVar CloseSeq objFileVar I found the above lines in one routine and i didn't understand the 100% functionality. Could any one explain me about the code in detail to me? Like the funct...

HI,

In one routine i have found a function using like

call DsLogInfo(Log Detail, "Job Control"). This function will add "LogDetail" to Log.

But What this " Job Control" does.

Madhu

Hi,

In Datastage Sequencer job, In job activity stage Trigger tab, i found a custom expression like

Jobname..$JobStatus>=0 and JobName.$JobStatus<=2

What this $JobStatus returns exactly depending upon the failures, success and warnings.

Can anyone helps me ASAP.

Madhu