Search found 459 matches
- Thu Oct 02, 2008 6:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Record count
- Replies: 5
- Views: 4137
This can be easily accomplished by writing a basic routine which counts the number of records on a *link* attached to a *stage* in a particular *job*. However, keep in mind that it is best to run this routine after the job which does the loading. As for the routine you can find plenty of them on thi...
- Mon Jul 14, 2008 10:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How does Partitioning work for more than 1 job
- Replies: 6
- Views: 3275
- Wed Jul 02, 2008 1:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: check for file existence
- Replies: 7
- Views: 4067
- Wed Jul 02, 2008 1:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Find String
- Replies: 3
- Views: 2841
- Mon Jun 23, 2008 12:15 pm
- Forum: General
- Topic: dsSurfer:An open source tool to make a few things in DS easy
- Replies: 1
- Views: 2182
- Sun Jun 22, 2008 11:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting Warning
- Replies: 4
- Views: 4126
This warning says that Datastage encountered a hex code which has no definition in the code page being used (ISO - 8859-1 in your case). If I were you, I would find out the hex codes not defined in this code page (Search wikipedia for ISO-8859-1) and search for them in my source and then find the so...
- Sun Jun 22, 2008 11:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: generating schema file
- Replies: 10
- Views: 6061
- Thu Jun 19, 2008 9:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: updating in wuery in Orcae stage
- Replies: 2
- Views: 2728
- Wed Jun 18, 2008 11:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Re-generating sequence numbers within list
- Replies: 7
- Views: 4171
You can declare a stage variable in a transformer after your sort stage which can be used as a counter. Input=====>sort===============>Transformer=========>output (create key change (Use the stageVar given on state) below to generate counts) counterVariable==> if not(ip.keyChange) then (counterVaria...
- Wed Jun 18, 2008 11:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Evironmental Variable in DS Transformer
- Replies: 2
- Views: 2154
- Wed Jun 18, 2008 2:12 pm
- Forum: General
- Topic: dsSurfer:An open source tool to make a few things in DS easy
- Replies: 1
- Views: 2182
dsSurfer:An open source tool to make a few things in DS easy
Hi all, I have started working on an open source tool which would make a few things easier for the datastage developer. Some of the things which I am planning to incorporate in this utility: Creation of job reports Schedule of backups Launching of datastage client components I am going to document e...
- Wed Jun 18, 2008 11:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Looukp reading 1 row at a time
- Replies: 12
- Views: 7686
I change to sequential, but obtain the same result. The sql query is select 1 as ind, seq.nextvl from dual; I use the ind = 1, to match with the lookup records. You can't drag and drop the key in the lookup stage when you are using a Sparse lookup. So something is wrong with your job. Now All you h...
- Tue Jun 17, 2008 9:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Looukp reading 1 row at a time
- Replies: 12
- Views: 7686
- Tue Jun 17, 2008 8:27 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Treat same files
- Replies: 8
- Views: 4621
- Tue Jun 17, 2008 8:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-01017: invalid username/password: Logon denied
- Replies: 5
- Views: 6119