DSXchange

I have a job that loads value data into a DB2 table. The source file has the values stored as a BigInt (15) whereas the target is set to Decimal (15,2). As the source values are in pence and we want to load as pounds I am dividing the source value by 100. So if my source value is 2079, I want to loa...

I have 3 Transform Jobs that are using a Shared Container to perform a lookup with a natural key to find the corresponding surrogate key from a dataset. If it cannot locate the key in the dataset it performs a lookup on the actual DB2 table and if it still can't find the key, it passes the row throu...

I have a process that reads an ASCII file in a Complex Flat File stage and passes it through a transformer and loads into a DB2 Table. Within the CFF, the Record Style is set to CR/LF and this causes an extra row of spaces to be added on the end of the file. When the process runs, it errors with thi...

In the DEV_75 project

Under jobs/shared/SEC_ARRG

UKWH_SEC_ARRG_IntUpon1job

I have tried the job with a transform stage in the middle but that didn't make any difference

In the DEV_75 project

Under jobs/shared/SEC_ARRG

UKWH_SEC_ARRG_IntUpon1job

I have created a very simple load job where I am passing a Key field and a date field into a DB2 table. I am simpling wanting to expire any records where the Key ID's are the same and the REC_EDT within the DB2 table is set to '9999-12-31'. The SQL is as follows: UPDATE #pUKDWSCHEMA#.#pTTABLESECARRG...

I have looked at both solutions given and have managed to get the FieldStore function to work fine for the initial value. However, what I didn't point out initially is that there could be up to 50 Codes that will need inserting into the one output line so how do I use 50 FieldStore statements togeth...

I have a job that creates an output line set to VarChar 1000 and which is comma seperated. And example of 2 rows is shown below. 5,16083,,,LGD,0079.1200 5,16222,EAD,000000000000000010,LGD,0094.5300 As you can see from the second row, there is a value of EAD (Score Type Code) and it's related value (...

I have used the following: Field(ResultsWrite2.LGD_CALC_VAL, ".", 1, 1) and Field(ResultsWrite2.LGD_CALC_VAL, ".", 2, 1) And for a value of 79.12 this gives me two values : 79 and 12. When I then do Fmt(LGDFirst, "R'0'4") where LGD is the StageVariable name for the firs...

Thanks for the advice.

Have managed to sort out the 18 character field removing the decimal point but am having problems with the other issue.

Basically how to convert a value such as 72.19 to 0072.1900 or 0.03 to 0000.0300.

I am needing to convert two type of numbers within a DS Server job. Firstly, I need to convert a number (e.g. 5.5) to the following format - NNNN.NNNN (in other words 5.5 would equal 0005.5000. Secondly, I need to convert a number (e.e. 15.50) to the following format - NNNNNNNNNNNNNNNNNN (in other w...

Much appreciated !!

Now works fine !

I have a flat file of Account numbers and account balances. There are examples where the same account number is repeated on more than one row with more than one balance. I am wanting to create just one row per account number with a sum of all the balances for that account. For example, below is an e...

I have created a job whereby I have a list of 14 digit account numbers which are passed into a shared container to find the corresponding Arrangement ID related to that account number. Initially, it does a lookup on a hash file and if it cannot find the account number it then does a lookup on the DB...

It is coming from the Mainframe (EBCDIC) and transferred to UNIX.
The datatypes for the fields are as above.

Cheers
JezT