DSXchange

Read my earlier post.

SQLState is for

You will not get it in an Oracle Enterprise stage.

Read the sequential file using a schema that is correct for the detail lines. Add a Reject link - this will capture the headers and trailer because they do not have the same structure as the detail lines. The Reject link can then lead to other stages that can re-parse the captured string (maybe usin...

Use the UNIX cal command. You can call the command from your job or routine. cal August 2008 Su Mo Tu We Th Fr Sa 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 cal mmm gives the calendar for month mmm in the current year. cal mmm yyyy gives the calenday for mont...

Use the UNIX cal command. You can call the command from your job or routine.

1. Prove that they are NOT NULL (a DESCRIBE would do, but the record schemas from the imported table definitions would be even better). 2. Tell us what stage types you have in your job. In particular, since the error message appears to mention a modify operator, do you have a Modify stage in the job...

How do you know to which year the y refers? Is it 1998, 2008, 2018 or something else (for example 8 years after some arbitrary zero year)? What will it be when your job executes in 2011 if y is 8 ? <rant> Who writes these specifications anyway? The need for this compression went away when disks beca...

Look in the log. Were checkpoints cleared?

Did you reset or recompile the job sequence after it aborted? This too will clear the checkpoint record.

Welcome aboard. You will need for U to log in again before U can say anything. The second person personal pronoun in English is spelled "you". Plz may or may not be a town in the Balkans - I assume you meant "please". "Hai" is acknowledgment in Japanese. A professional standard of written English is...

There are default maximum sizes for rows and columns processed via ODBC, which can be overridden by entries in the uvodbc.config file either globally or on a per-DSN basis.

Why did you choose to post in the forum for suggestions about the DSXchange web site?

Welcome aboard. The last time I did this it took 6 hours, and that to people experienced with 7.5. Admittedly it was more "what's new" rather than just architecture, but the architecture considerations alone took probably an hour of that. I don't propose to be sitting here typing for that long! Ther...

Consider ways in which you can build in some parallel processing, for example multi-instance jobs. Can you create an Oracle table of the distinct transaction IDs and join to that, to minimize the number of rows that you need to extract from Oracle? Such a table is called a "bucket table" - it contai...

Who cares? It's the right value. You can format however you like once it's in Excel.

Which of the errors? Most have been discussed before - search for them individually. Particularly the number of datasets one.