DSXchange

Is there not a simple answer as to how to do it within DataStage and then I can do the "earn and learn" later. It's just that we are working to a pretty tight deadline and this requirement has only just been discovered !!

The PICture definition of the source field is PIC10(10).

What do you mean by compiler ?

And there won't be any negative numbers in the source field.

The SDK Routine DataTypePicComp converts a COBOL PIC COMP into an integer.

Is it possible to do the reverse (i.e. convert a CHAR field into a COBOL PIC COMP) within datastage ?

I am running a job that produces a three column sequential file. One of the columns is a 10-digit Customer Number that has leading zeros if the number is not 10-digits long. This file is transferred to another department for them to input on to their system but before it is transferred, the customer...

I am running a job that produces a three column file. One of the columns is a 10-digit Customer Number that has leading zeros if the number is not 10-digits long. This file is then transferred to another department for them to input on to their system. They have requested that the Customer Number fi...

I am wanting ao add leading zero's to a numeric field if it is not 10 characters long.

I know the FMT Function is used for string fields but what can I use for a numeric field ?

I am wanting to do some data checking on several fields within a source file.

I need to check that 3 of the fields only contain numeric characters otherwise the row should be rejected.

Any suggestions ?

I am trying to access some of my jobs but keep getting the following error:

This item has no design time information

I have re-indexed the project as has been advised on another topic but this has made no difference.

It is not happening for other jobs, just this one.

Any ideas ????

I am using a shared container to look up a surrogate key for a given natural key. However, the problem is that the column in the source file which is used as a natural key relates to 2 different fields within the DB2 table in the shared container. Therefore, depending on which row is being passed in...

I have a load job that is adding a field to a Customer DB2 table. In my source file that I am loading up, I have 18 rows (2 different rows for each ID of 1-9). If I do a lookup on the table and then add the data directly to the DB2 table (so that the lookup and target table are linked to the same tr...

I have created two after job routines. One adds a trailer to the output file from a job and the other is meant to add a header. The problem is that although the Write Trailer works fine, the Write Header routine is adding the line at the bottom of the file and not the top. Any suggestions ? Is there...

Cheers Rasi

That works a treat !!

Jez

I have a file of about 10,000 rows in with 3 columns (IP_ID, CDU_CIN and PTYP_SVAL). Most of the rows have unique IP_ID's (which is the Key field) but there are some that have duplicates. I am wanting to strip out these duplicates and to leave the occurence of the IP_ID which has the highest value i...

I have a file consisting of multiple rows containing multiple Surrogate Keys concatenated together against a single Natural Key. For example, Surr Key Nat Key 1:2:3:4 ABC 5:6:7:8 DEF I am now wanting to split this concatenated string up so that for every instance of a surrogate key, a row is created...

Craig

The only problem with that is the source table does not actually contain Quarter Hour Slots. It contains a time that the telephone call was received and then this is passed into a transformer which calculates which Quarter Hour Slot within the day that call falls into.

Jez