DSXchange

Code it yourself. Use a constraint expression such as Use an Otherwise/Log output link to capture the too-long strings.

If you want to generate a warning, you can create a routine that passes its argument through unchanged but called DSLogWarn() in its code.

Capture the date from the header into a stage variable. Compare this value with the value in detail records.

Why do you always post UNIX solutions on a DataStage forum?

Why such large arrays? Bring it back to the default, say 2000 or 5000. See if that works. Then ramp it up gradually. Get the DBA to help with keeping the transaction log clean. Beware of any long-running transactions.

If you're completely replacing all the records, why not truncate the table?

What issues? Your question is currently in the "my car won't start" category. More information is required. Find out exactly what "customer DB2 team" did. In particular did they change the administrator user/password, or change it to expire, or something else? Does the WebSphere ...

It is only easy to use in Server jobs. Every job has a reserved area, called its user status area, into which any value can be placed while the job is running. The value in the user status area can be interrogated once the job has finished, most usually via an activity variable in the controlling se...

mmanes wrote:I cannot spend $99.

Less than 30c per day. How much do you spend on coffee?

Download ETLstats for free from Kim Duke's website - he's already done all the hard work for you.

I did address that in my response. You need to get yourself a premium membership to be able to view the entire response from the five premium posters. (This is the mechanism by which DSXchange is funded.)

How are your data partitioned on the inputs to the Lookup stage (assuming it's first after the Connector stage)?

Or was it 8.5 FP1 ?

Make sure that the Precision setting in the Columns grid is not blank.

Read each line as a single VarChar and parse in a Transformer stage. Use a stage variable to conserve the file name from the header row. Get version 9.1 in which the target Sequential File stage can distribute data as you specify, based on the second field value in the header row. Otherwise, and pro...

Your Oracle date picture ('YYYY-MM-DD HH24:MI:SS') does not specify an AM/PM designator - it specifies a 24 hour clock. Therefore DataStage isn't "disappearing" anything - your other viewer is ADDING the AM/PM designator.

You can use an Oracle sequence in user-defined SQL, for example INSERT INTO myschema.mytable(C1,C2,C3) VALUES mysequence.NEXTVAL, ORCHESTRATE.C2, ORCHESTRATE.C3); I leave it to Poovalingam to explain how to invoke within a Transformer stage; it's not something I'd do directly. Instead, I would conne...