DSXchange

1. DataStage job logs are stored in database tables. 2. Apart from restoring from backups, no. 3. Because, by default, there is a filter on the log that limits you to the most recent 100 entries. Look for the word "Filtered" in the status bar. Use Ctrl-T, or a right click in the log view, to open th...

In what format is the date/time in the CSV file? If it is correct for your Oracle settings, then (as others have observed) you need to do nothing. Otherwise you can re-arrange the string components with substring and concatenation operators.

I don't think the question was about removing stage variables: I think it was about removing duplicates using stage variables. Then again, it could have been about showing understanding in Japanese, who knows? As far as I am aware there are no such things as stage variables in TX.

Range lookups are supported in the Lookup stage in version 8.0.

"Update existing rows only" is NOT "user-defined SQL". Examine the list of possibilities a little more closely.

However, the DDL tabs are only enabled when you check the "create table" check box on the General tab. I misread your original post.

You don't need a loop - just multiple Job activities each referring to the same multi-instance job but with different invocation IDs.

<irony>Create as many as you like - everyone knows that a DataStage server has an infinite supply of CPU, memory, disk and network resources!</irony>

Go to the Columns grid and edit the extended metadata for the Nullable column. Set its Null Field Value property (in the Nullable folder). If the sequential file is fixed width then the number of characters in the Null Field Value property must exactly match the number of characters in the field its...

There is no particular pattern. You will note that the one in the original error message contained an @ symbol and a hexadecimal suffix (which I'm guessing provides uniqueness in some fashion).

Perhaps we need to patent a product called Metatron to manage it all! (If you've read Good Omens by Neil Gaiman and Terry Pratchett you'll know what Metatron is, at least in one context.) It's been reported that Metatron has more than 100 names; if that's not a case for metadata management I don't k...

Yes it's possible. Use a job sequence, a shell script, a batch, or a job control routine. Whatever method you use (search the forum for techniques) you must extract the values from the file and supply them as job parameter values before requesting the job run.

Find a tab in the stage called Link Execution Order (on the Inputs tab). This will show which is which and, indeed, allow you to change them. Once your voyage of discovery is complete, why not use small annotations to label the inputs on your graphical job design?

All metadata, including design-time metadata, are saved in IIS repository. That's one of the main thrusts of version 8. During the transition some of the metadata may be replicated in the "traditional" DataStage repository, but don't rely on this being complete and don't rely on it continuing into ...

Had you mentioned in the original post that "they" had re-created the database instance you may have had that response sooner. Curious that you use bind19 rather than bind20 - what version of DB2 are you running?

Why can't you open it? Use Word if you must. Just remember to exit without saving. Word can even add line numbers (File > Page Setup > Line Numbers... > Add line numbers).

This demo is really interesting if you're interested in working with visual data. About 6m20s into the talk the presenter uses the term "metaverse" to describe totally shared and interlinked metadata.