DSXchange

Usage analysis is doing that for you. Go to the manager. Mark the transform/routine you are looking for. Klick right mouse button and choose "usage analysis". You will receive a the list of jobs using the specific transform/routine.

Klaus

Tony, are you still having this problem? What is your exact environment (Solaris 8?, DS 7.1r1?). If yes, there is a specific issue with this Solaris release which leads to similar problems to describe.

Please contact Ascential support.

Klaus

The only reason I see why not using DSLogFatal in a transform is that it is "not a good practice". You have, of course, to take care of the abort situation of the job and the further processing of your sequences... However, in very rarly cases I do so and I don't see technical reasons in n...

Eric, there's not routines coming with datastage to convert server data back to mainframe packed format. What you have is ascii - ebcdic conversion. Based on the existing routines you might be able to write your own routines, or someone in the community may be able to provide these. On the other han...

Srimitta,

I suggest you attending a DS390 training or get yourself just a few days of consultancy support

Klaus

Srimitta, 1. You cannot "import" COBOL-Code into DS390. DS390 COBOL code is generated based on its own internal logic for designs you create. It's not a reverse code engineering tool. 2. You can upload the generated code/jcl etc. any time from outside datastage. All you have to do is ident...

Or, similar, as I do in most of my projects: 1. Start each child sequence with a routine to set the UserStatus to 'NOK' 2. End each child sequence when the last job runs ok by again calling the same routine setting the UserStatus to 'OK' 3. Now, in each caller sequence you can trigger the follow up ...

Nag,

you can still use the udbload stage and use the load deferred option. You can then start the loader from command line or unix script.

Klaus

The load client switch seems to be there with version 7 only. Speed? I'm currently loading 1mio rows in about 5 minutes (heavy utilized AIX machine, one processor only...)

Klaus

Yes, that's no problem for datastage. You can either use the CFF stage or apply the DATATYPEPICCOMP3xxx transforms coming with the sdk. In both cases, be sure to have the original mainframe ebcdic data (must be ftp'ed in binary mode down to your server!).

Klaus

Hello Sairam, for stage variables you can set derivations in the same way you do it for other derivations on your link output data. So you simply set something like IF INCOM.ROWA = 10 Then 'OK' Else 'NOK'. Since DataStage operates simply sequentially, and stage variables keep their values until bein...

Kusuma, let me guess two options on this file: 1. You could use CFF. However, CFF expects fix length records. Since it is a delimited file you have to take care of it, at least you need to define "fields" for the delimiters. 2. Use a regular flat file stage. Read all data into a single &qu...

Exactly,

Data that overflows a group of a dynamic hash file goes into this overflow area. If you find this data growing much, your hash file is probably not very well configured.

Klaus

Endy,

what do you really want to control??
A records is passed in sequence with the the transforms you are placing.

Klaus

You may probably use the MERGE stage to do this. This is the only way to merge 2 files for input and continue with one output stream.

Another possible option would be to read one of the files with a surrogate key into a hash file and then have it in a transformer as a regular lookup.

Klaus