DSXchange

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...

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...

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...

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...

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...

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...

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 ...

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...

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...

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...

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...

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...

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...

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...

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...