Search found 7201 matches
- Thu Mar 04, 2004 9:23 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: How to import files w out editing, for tbl defs
- Replies: 2
- Views: 10660
How to import files w out editing, for tbl defs
Question : In attempting to import column names from a text file to create colm names in a tanle definition, in DS manager. Desired result : Get extensive number of column names for a large file into DS Manager Table Definitions so it can be downloaded to an input file in a DS job. without having to...
- Thu Mar 04, 2004 7:33 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Elusive Missing Data Fields
- Replies: 4
- Views: 21375
Elusive Missing Data Fields
Wow - thanks for the checklist! It turns out in our case that every time a field value was lost, it was a value of length 5 in a field of length 6. While we couldn't see what the extra character was in those fields (and we tried everything!!), the problem obviously revolved around that issue. (Altho...
- Thu Mar 04, 2004 12:55 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Elusive Missing Data Fields
- Replies: 4
- Views: 21375
Elusive Missing Data Fields
Hi Lindi, the "VIEW DATA" is a help visualation tool. The real relevant part to look at is the output. It is known, that with VIEW DATA you sometimes don't see things which are in reality present, we know this and we respect this. (1) So use an editor for to check you input and your output...
- Wed Mar 03, 2004 2:29 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Elusive Missing Data Fields
- Replies: 4
- Views: 21375
Elusive Missing Data Fields
Thanks for the ideas, Eric. We tried them both - I wish I could tell you that one of them solved my problem! Your suggestions did get us looking around more in the field setups, though, and after three hours of getting nowhere, we decided to change the job to define each entire record as one huge fi...
- Wed Mar 03, 2004 12:11 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Elusive Missing Data Fields
- Replies: 4
- Views: 21375
Elusive Missing Data Fields
I've had 2 problems that sound similar.... so not sure if they're related or not: 1) I've had times where my field sizes are all set up correctly, but my DISPLAY sizes are not. Although i don't think that should have impact on processing, it's actually caused my programs to NOT work correctly and me...
- Wed Mar 03, 2004 11:03 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Elusive Missing Data Fields
- Replies: 4
- Views: 21375
Elusive Missing Data Fields
We have a job that reads a simple, fixed-length, sequential file. When we view the file in a text editor, data shows up in a certain field. BUT - when we view the file inside the sequential file stage in the designer, SOMETIMES the data in that same field does not appear (and it's also not processed...
- Tue Mar 02, 2004 2:48 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: XMl output with the closing tags
- Replies: 1
- Views: 15813
XMl output with the closing tags
My output is in the following format from the XML writer stage. TotalPayment: 1241234 1561978 6789999 5634444 Could some let me know how to get it into the following format. TotalPayment: 1241234 1561978 6789999 563 In summary I need a closing tag of for the Subtotal, if there is no Balance. Thanks ...
- Tue Mar 02, 2004 2:45 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: XMl output with the closing tags
- Replies: 1
- Views: 15813
XMl output with the closing tags
Actually, you don't need a closing tag. The tag you have is a closing one. Whenever you see a tag with a slash right before the ">" sign, it is both an opening and closing tag. ksurapan@hartfordlife.com wrote:My output is in the following format from the XML writer stage. TotalPayment: 124...
- Tue Mar 02, 2004 2:21 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Reference atlas.nextval from oracle
- Replies: 8
- Views: 32392
Reference atlas.nextval from oracle
Excellent!! I think this will work and gets me in the right direction. Thanks everyone for your help. -----Original Message----- From: datastage-users-bounces@oliver.com [mailto:datastage-users-bounces@oliver.com] On Behalf Of Malathi_Vellanki@mckinsey.com Sent: Tuesday, March 02, 2004 1:59 PM To: D...
- Tue Mar 02, 2004 1:59 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Reference atlas.nextval from oracle
- Replies: 8
- Views: 32392
Reference atlas.nextval from oracle
How about using OCI stage to look-up/reference 'select atlas.nextval,1 hardcoded from dual' as user defined query. 'hardcoded' can be joined to another hard coded value in transformer. Suresh Chilukuri .state.nj.us> cc: (bcc: Malathi Vellanki/FIRNY/NorthAmerica/MCKINSEY) Sent by: Subject: Re: Refere...
- Tue Mar 02, 2004 1:43 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Reference atlas.nextval from oracle
- Replies: 8
- Views: 32392
Reference atlas.nextval from oracle
Ray, what if you need the nextval in the transformer stage because you are also using it for foreign keys in other related tables? Would you break the process into a separate job for every table and then reference in that table for the foreign key? -----Original Message----- From: datastage-users-bo...
- Tue Mar 02, 2004 1:32 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Reference atlas.nextval from oracle
- Replies: 8
- Views: 32392
Reference atlas.nextval from oracle
Hello Rob - We use this on our DataStage/Oracle jobs. Here are the steps we use: 1.) Set up a specific Oracle sequence for the table you will be writing to in Oracle. 2.) Design DataStage job to have an update path and an insert path. 3.) On Insert (so lookup is Null), have an Oracle Stage lookup th...
- Tue Mar 02, 2004 1:30 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Reference atlas.nextval from oracle
- Replies: 8
- Views: 32392
Reference atlas.nextval from oracle
It's easy and it's exactly what you do with Oracle. In your ODBC or ORAOCI stage use user-defined SQL. Assuming it's an INSERT, refer to the sequence's NEXTVAL property to supply the value. And - here's the trick - your DataStage job does NOT provide a value for this column. So your SQL has the appe...
- Tue Mar 02, 2004 12:02 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Reference atlas.nextval from oracle
- Replies: 8
- Views: 32392
Reference atlas.nextval from oracle
I think you can use database triggers to generate sequence numbers. Robert Takkunen wrote: > Does anyone know of a good way to reference in the next value from Oracle > into a DataStage server job? We are building a database in Oracle with > DataStage and need to write the id's along with using thos...
- Tue Mar 02, 2004 11:53 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Reference atlas.nextval from oracle
- Replies: 8
- Views: 32392
Reference atlas.nextval from oracle
Does anyone know of a good way to reference in the next value from Oracle into a DataStage server job? We are building a database in Oracle with DataStage and need to write the id's along with using those id's as foreign keys in other columns for tables in the same DataStage job. Thanks - Rob Rob Ta...