DSXchange

The key column does need to be in the columns list of your user-defined SQL, but NOT on the Columns tab of your input link, because DataStage is not providing the value for the key column.

There isn't one. From the Administrator client command window you can execute a query in the project to which you're actually connected, counting rows from DS_JOBS whose keys do not begin with "\\" and whose job type is not "sequence". But that's the count only for one project. Y...

It's a hashed file, so in DataStage BASIC you can open it with OPEN, read it with READ and close it with CLOSE statements. The key to the control record is, from memory '\\NLS'. If you want to work from an operating system command you can use UVread while attached to the project directory. Syntax in...

You have definitely specified comma as the delimiter in the StartLoop activity? Please check.

Why should you get an error? Two points. DataStage can elect not to use cache, and will log a message if it does, but it's an informational message. And a 1.5GB hashed file does not necessarily contain 1.5GB of data - when was it last compacted? ANALYZE.FILE can show the amount of free space within ...

crouse wrote:figgered

Don't worry, I promise that you'll get a Yay! too, when you get to 20000 posts.

What type of stage is throwing the error? Also, what has changed between when it was running successfully and "today"? ("Nothing" is not the correct answer.)

How many columns in your design? You only have two parameter markers, so you require precisely two columns in the design. Specifically you do not include the name of the key column in your design. Just col1 and col2.

Your first job is to find out what kind of file it is. That a CSV file opens in Excel is perfectly normal because CSV is associated with Excel in your Windows environment. You need to bypass that association, for example using "Open With..." from the right-click menu. If all is good you ca...

Abhyankar wrote:Hi,
I have generated a Sequence in DB2. How can i import or use it in Datastage? I want to use it as a key generator in my Job.

You can use its NEXTVAL property in any SELECT, including on a reference link. Just don't expected it to be fast.

Sounds like you've got some repair work to do. Make a complete list of those that do and those that don't have DATA.30, OVER.30 and .Type30 only. (Exclude RT_BPnnn and RT_BPnnn.O - these are ordinary directories.) Then execute LIST.INDEX against each of the DS_* hashed files (in Administrator client...

OK take a look inside the DS_* directories. They should - MUST - contain precisely three files, called DATA.30, OVER.30 and .Type30 (the last is a hidden file). If there are fewer or more than these, then again someone has broken your project. If there are more you can delete the surplus files and i...

The one with 20000+ posts, not the one nearing 200 posts.

You need a parameter marker or reference to the ORCHESTRATE structure, not the column name. For example one of the following. SELECT RATE_STERLING from CURRENCY_RATES_DIM where ? >= CURRENCY_RATES_DIM.START_DATE and ? <= CURRENCY_RATES_DIM.END_DATE SELECT RATE_STERLING from CURRENCY_RATES_DIM where ...

You might like to search here and elsewhere to learn why computers can not precisely store real (sfloat or dfloat) numbers.

Convert to decimal before effecting any comparison - you can preserve the floating point numbers, but compare the decimal numbers.