Search found 73 matches
- Mon Jun 02, 2008 7:52 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Losing Decimal Values
- Replies: 2
- Views: 1694
Losing Decimal Values
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...
- Wed May 14, 2008 3:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Shared Container Error
- Replies: 1
- Views: 1340
Shared Container Error
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...
- Thu Sep 27, 2007 7:23 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Complex Flat Files adding extra row
- Replies: 4
- Views: 2718
Complex Flat Files adding extra row
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...
- Mon Oct 16, 2006 2:19 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Expire Only Load Jobs
- Replies: 8
- Views: 3371
- Mon Oct 16, 2006 2:19 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Expire Only Load Jobs
- Replies: 8
- Views: 3371
- Mon Oct 16, 2006 1:58 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Expire Only Load Jobs
- Replies: 8
- Views: 3371
Expire Only Load Jobs
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...
- Tue May 30, 2006 4:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Inserting Data into single comma seperated row
- Replies: 7
- Views: 3383
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...
- Fri May 26, 2006 4:29 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Inserting Data into single comma seperated row
- Replies: 7
- Views: 3383
Inserting Data into single comma seperated row
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 (...
- Fri May 19, 2006 8:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Number Formatting
- Replies: 13
- Views: 4479
- Fri May 19, 2006 8:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Number Formatting
- Replies: 13
- Views: 4479
- Fri May 19, 2006 5:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Number Formatting
- Replies: 13
- Views: 4479
Number Formatting
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...
- Wed Sep 28, 2005 6:46 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Merging Rows
- Replies: 2
- Views: 2335
- Wed Sep 28, 2005 6:07 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Merging Rows
- Replies: 2
- Views: 2335
Merging Rows
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...
- Fri Aug 05, 2005 1:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error In Assignment
- Replies: 1
- Views: 1371
Error In Assignment
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...
- Fri Jul 15, 2005 4:07 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Zoned Decimal Fields
- Replies: 9
- Views: 4907
It is coming from the Mainframe (EBCDIC) and transferred to UNIX.
The datatypes for the fields are as above.
Cheers
JezT
Code: Select all
03 TOT-NUM-PUB-INFO PIC 9(01).
03 TOT-VAL-PUB-INFO PIC 9(03).
03 MNTHS-SINCE-INFO PIC 9(02).
03 NUM-NON-MAIL-CAIS PIC 9(01).
Cheers
JezT