DSXchange

Now I have no idea of what you really want to do. Could you perhaps explain with a small example of what you want done?

Start off with a simple test - go to the project directory and list the files ordered by descending size. The data for the most common file type, DYNAMIC, is contained in a DATA.30 and OVER.30 file inside a directory which is the hashed file name. So, are there very large log files? If yes, you can ...

Make two separate links go to two DB2 stages. Make the DELETE command commit immediately and order it so it executes before the normal insert link.

Thanks, I was too lazy (and my internet connection to slow) to get that again and add it to the post.

would be use to see if the column "In.Column" is a valid 32 bit integer.

Rex, If you are looking at the SQL used within DataStage to access hashed files then you are out of luck looking for it in the DataStage documentation. You can, however, download the manuals from the UniVerse documentation on IBM's site and be fairly certain that most commands will work since the tw...

When you get a message to the effect that the column is already bound look at your RCP status for that stage - it is probably turned on and you have re-assigned that column name.

You have two main ways of getting the file - using FTP from your system or using DataStage FTP. In the former, you should google your OS name and "ftp script" because each flavor of UNIX is a bit different in how it allows scripting the commands and you might find an example for your mainframe OS co...

If DataStage cannot output to a text file, which is what this temporary shell script is, then it is almost certainly because your userid has insufficient access (specifically "w"rite access) to that directory.

It seems that the Oracle enterprise stage only allows for setting the row or time based commit frequency at a job level. I have a job where I would like to set the main data output, which uses the write method, to as long a time and as high a row count as possible (using the 2 oracle environment var...

Hello and welcome to DSXchange. Before posting, it is wise to read this FAQ , which also explains how to use the search facility. When you do so, you'll see that this is a common problem or question that most PX job developers will have encountered - the ones that haven't seen this warning just have...

I should be more specific. You should write a DataStage job to read the file (defined as one big column without deliimters) and then, in a PX or BASIC transform stage, apply the logic discussed earlier in this thread. There is no need to write a routine to do this.

What? Use a DataStage job to open and read the file!

Well, since you are a charter member, here are my numbers:

and Bob's your uncle as some Yorkshire friends of mine are prone to saying.