DSXchange

Shivan,

could you post the SQL statement please?

Usually you have a choice of what delimiter to use in DataStage jobs, i.e. you can make a derivation "hello world" or 'Hello world' and \Hello world\. If you have all 3 delimiters in a single string then you need to improvise, i.e. x = 'This is a "':"'":'" singly and doubly ':/ "'confusing'"/:' stri...

I you remove the WHERE clause then the VIEW should work; what is happening in your case?

Try to connect to a hash file using ODBC and use "localuv" with no user-id or password.

Just for reference, how long does this SELECT take when done from SQLPlus? Also, can you not get your DBA to trace this select when issued from DataStage to see what is happening? Also, if you do a "view data" in the designer, does it correctly resolve all your parameters? Does the "view data" work ...

There were also a couple of threads on this subject, I remember one where Lance and I talked about the differences; I did a test where I used a Lookup set and Data set and was surprised at the lack of performance differences. http://www.dsxchange.com/viewtopic.php?t=93287&highlight=lookup+dataset

Adamski, DataStage itself is not aware of the underlying OS's handling of processes and cannot automatically influence execution priority. The standard commands to let users change their own processes' are UNIX "nice" and "renice". You can usually only change your priorities downwards (which is what...

When you use the SELECT and LIST commands in TCL it will read the DICTionary items of the columns that you show and format them according to that item's format clause. You can override that by using the FMT {format} construct on the TCL command line: So you could write "LIST MYFILE X FMT '12L'" to f...

Your commit size is the deciding factor here. If the job fails before doing a commit any database changes will be rolled back. This is a great feature, but when doing very large inserts into database one is often forced to specify a commit size so that the rollback segment(s) in the DB aren't filled.

Kumar,

I have 7.5.1 on AIX and couldn't find it either, perhaps Ray is referring to a Windows-only executable... especially as UNIX does have a "find".

I only have one word - reinstall

sorry...

Dave, you just re-opened an old thread (6-months!); it might be better to create a new post with the question. The .dsx is a structured text file; any binary data is included in uuencoded form. You can use your favorite editor (notepad might not be a good choice for large files, though) to look at i...

Hard work, mad skillz and an intimate knowledge of the internal structures of PX jobs. And it can be all yours for only... [puts little finger in mouth]... one million dollars. (sorry) Craig - thanks, that was my first (and perhaps only) laugh of the day, the others here in the office think I've fi...

Naveen, What I did was to load the metadata for all the DB/2 columns and Oracle columns, then I wrote a program which read this metadata and made sure that I had a list of all conversions that were done (date/time to timestamp, date, char, varchar, integer, decimal[m,n], etc). Once I had a list of w...

Take a good look at the "dir /s Processed.txt" command in dos, this will give you a list of the files found. You can write a Function that calls this command and gets the result in a string.