DSXchange

So you're saying that if you simply hide the column datastage ignores the fact that some columns have level values and some do not? Seems simple enough.

I'm creating datastage jobs to land mainframe data in to datastage datasets. I'm reading mainframe data using the Complex Flat File (CFF) transform. I used copybook data files to define columns in the CFF which includes level information. I then produce a datastage data set file which I noticed incl...

Thanks Ray.
I'll probably be doing a POC on this.. If/when I do.. I'll update the post.

Is there a way to create a generic datastage job to read a database (DB2) table specified as a parameter. Perform a select * from <table_nm>. And then have the columns propagate directly to a <table_nm>.ds dataset? I read about the runtime column propagation setting. Has anyone every used this featu...

I have a datastage parallel job with 4 CFF transform readers set up as sources calling a shell script that performs an NDM file transfer from a mainframe. As additional information... All of the CFFs are being sent through a sort funnel to get a sorted union of all the records. The problem I am expe...

I'm working with a client that is relatively new to DataStage and has mainly dealt with COBOL on the mainframe. They are enquiring about the ability of DataStage to mimic the concept of 'Unit of Work'.... Is there a way to package a DataStage job to commit related records to multiple tables? Is ther...

Is it possible to implement an NDM call using an External Source or some other means so that the NDM source does not have to be landed before processing? The thought was that if the FTP source is doable, an NDM source would be very similar.

Thanks Mike! The link worked.
I need to go to a remedial forum search class.

I would like to have the file name associated with a record added to each record so I can process the records in order. The file name starts with X and has a date time added to the end of the name. When I added the FILE_NAME option and the READ METHOD = File Pattern and set the File Pattern to X*......

So... you've added a new field in a transformer for the result of this calculation and made it Numeric 10. What is your derivation? What are the datatypes of the fields used? Correct... I'm not sure if the transformer '-' can be overloaded to use 2 timestamps. The calculation I attempted was a simp...

Subtracting two timestamps would give you the difference in seconds, so you'd need to multiply the result by 60 and decide how to handle any fractions. What have you tried so far and what happened when you tried it? Maybe I'm just not declaring the result correctly... I declared it as Numeric 10. I...

I am attempting to get the difference betwenn 2 timestamps as a result in minutes.

IE: Timestamp1 - Timestamp2 = X minutes (Numeric).

I can do it within the Oracle SQL query, but I'd like to do it within DataStage.

Some examples of values where it succeeds and, particularly, where it fails may aid the diagnostic process! You should be able to capture these via a Peek stage connected to the Transformer stage's Otherwise/Log output. After much pain, I have figured out the cause of the SIGSEGV error. When using ...

You may need to provide a format string for the timestamp. The default default for Timestamp is "%yyyy-%mm-%dd %hh:%nn:%ss" but your data seem to be "%mm/%dd/%yyyy %hh:%nn:%ss". Sorry... It was 2am when I posted. The format for the date is in the default format. I've corrected t...

I'm trying to create an Integer value representing the Time from TimeStamp without seconds. IE: Given a Timestamp of 2006-03-31 01:20:45 I need to create a TIME_KEY equal to 12000. The following works when there are time values > 00:00:00...... If IsNull( to_create_keys.ADMIT_DT) Then -1 Else ((Stri...