DSXchange

Learn patience. DSXchange is an all-volunteer site, where people post as and when they can, and usually don't if they have nothing to contribute. "Pushing", as you have done, may be regarded as offensive. If you need the answer urgently, sign up with your support provider for premium service, and l...

DSD.StageRun is the internal DataStage routine that executes the code generated by compiling a Transformer stage in a server job. $R63 is the name of an internal variable typically used for an intermediate result. A simple example is the expression Oconv(Iconv(Field(InLink.TheTimestamp," ",1,1),"DMD...

You're going to need substring, because you have to convert your date and time separately. In your case the time component does not require conversion so may simply be appended to the converted date. Oconv(Iconv(Field(InLink.TheTimestamp," ",1,1),"DMDY"),"...

Welcome aboard. The Lookup stage (on which you received this message) is being serviced by a reference input link on the other end of which is a Lookup File Set stage. When the Lookup File Set stage was populated, its key was defined. You are "locked in" to using this key - the Lookup stage will not...

Why "in a buildop"? There's a perfectly reasonable function for this in the Transformer stage. Why re-invent the wheel?

Resist stupid requirements.

@DATE is already in internal format - so you don't need Iconv().


To pre-empt Craig, "that's certainly one variation".

If you're writing to a sequential file there's no notion of a key - you just write a line at a time. The only time REJECTED would be triggered is if you couldn't write to the file at all, for example disk full, quota exceeded, file size limit reached, no write permission.

If a table has no primary key you can insert the same row as many times as you wish. There is nothing to enforce uniqueness.

Did you not get them because you didn't search for them or did you not "get" them meaning that you did not understand them? The easiest solution, where the job is run monthly (presumably on the last day of the month) is to generate the base file name (xyz.txt) then use an after-job subroutine such a...

You could use the $Counter property.

But the job, if it is inside the loop, will complete before the loop re-iterates, so it does not need to be multi-instance at all. Nor does it need an invocation ID.

Would you care to explain how this affects the File Name property?

Try including (SMTP) Server in your call.

It's a file in the project directory on the server.

Then perhaps you had better check that the 'dssendmail_template.txt' file includes a %from% token.

And what is that message telling you?

There's no "From:user@domain" (that is, sender) in your string.