DSXchange

I've come across a job that selects data from a database table and populates a hash file. In particular, one source column has a datatype of char(40) in the source system. However, in DataStage the column has been defined incorrectly as char(10) and is passed through as such to the hash file where t...

Thanks guys.

Great solution - simple and fast!

We're seeing a very strange situation here... When we reference the Macro DSJobStartDate in a stage variable calculation, the throughput for our job is 85 rows/sec. However, when we remove the reference to DSJobStartDate from the stage variable, and simply reference DSJobStartDate in a column deriva...

I have a number of COBOL FD Table Definitions that were previously imported from copybook (.cfd) files. Can I 'reverse engineer' the actual copybook file (.cfd file) from DataStage if it's defined in the Table Definitions?

Thanks!

Peter

I realize that this topic has been posted ad nauseum, but I'm stumped by this particular occurrence of the problem... We have a job that usually runs properly. However, once every week or so, the job terminates with the following error: Abnormal termination of stage DW_AdjJob..X_Transfer1 detected W...

Within the Teradata MultiLoad stage there is an option to "Use Named Pipe". I'm curious to know what the advantages and disadvantages are for using named pipes in a Multiload stage. I'm particularly interested in hearing about whether other users have found this to be a stable option in hi...

After reading chapter two of the DS Server Job Developers Guide, I'm still a little fuzzy about when IPC stages should be used within a job for which inter-process row buffering has also been enabled. It is my understanding that if I enable inter-process row buffering for my job, then there's no poi...

Even if I can't pass this character through "as is", can I map it to a fixed value instead?

Great! Thanks for the replies!

Quick question here (I hope!)...

Can multiple jobs read concurrently from a single sequential file?

Thanks!

NLS is disabled.

I would like to obtain a list of all jobs in all projects on a single DataStage server that reference a particular Teradata table. Is that possible to do without Metastage?

Thanks!

Peter

Thanks to both of you for the valuable info.

Cheers,

Peter

I'd like to write to a single hash file from multile concurrent jobs. Previously I've written to a hash file using multiple inputs within a job, however, is writing to a hash file from many jobs supported?

Thanks,

Peter

Thanks to both of you. You've been very helpful.

Cheers,

Peter