DSXchange

Not with server jobs. Typically you'd use cat as a Filter command in the Sequential File stage that reads them. (The Funnel stage in parallel jobs does have an input-at-a-time method.) Right now I'm constructing header/details/trailer files using a job sequence; three activities (among others) - one...

SETFILE is in the UniVerse doc set.

Are you permitted to use a server job for small volumes?

The reason behind Sainath's suggestion is that @TIME is set when the job starts, whereas Time() captures the system clock value at the moment it is invoked.

Joined? Nah - they were taken over with some of the billion dollars Ascential got for the Informix databases from IBM.

Maybe the process has already been killed (naughty!) without first releasing locks owned by that process. Now you have locks held by defunct process. Ooooh! The easiest way to get rid of those is to re-start the server. They can also be released via the DataStage deadlock daemon, either in interacti...

No.

Think about it. I want to concatenate "abc" to an unknown value. What is the result?

"It's not working properly" is not a sufficient diagnosis.

It's actually an issue within Teradata itself. For whatever reason locks in the AMP lock table are not being released, or maybe simply the demand for them is too great. Work with your DBA to resolve.

Has anyone had a chance yet to play with using port #22 with the FTP stage in version 8.1 ?

If so please post your observations here. Did it work? Did it work well? How (in the stage design) did you specify the keys file on the remote server?

Modify stage has lookup_int16_from_string() function, sounds ideal for what you require. It also has functions for extracting date components. If you want to do it in a Transformer stage, create a 36-character string with all 12 month abbreviations, then use Index() to determine the location of the ...

Do a bit more research. Checking whether a file exists is most easily done with a Wait For File activity, but can reasonably easily also be done with an Execute Command activity. Use the $JobStatus activity variable associated with the Job activity to determine whether or not to run an Execute Comma...

As a matter of principle we don't even attempt to diagnose messages from APT_CombinedOperatorController.

Disable operator combination then run again, and advise the actual message (including the stage that generated it). It would probably be useful also to post your job design.

Try the ODBC driver for text files. (It might be horribly slow, however.) Another possibility might be to load your text file data into UniVerse tables and effect the complex join there. (Again this will be slow, because indexes can not assist LIKE joins.) However, you can create I-descriptors (virt...

I think this one is best done in the database. It's a complex, non-equality join requirement (potentially with three LIKE conditions with OR conjunctions), something DataStage is not really equipped to do.