DSXchange

Gen1715 wrote:Can this be done only in sequential file

No, not directly. You could however leverage an O/S command like awk in the Filter property to pass in only those three columns to the stage.

chandra.shekhar@tcs.com wrote:(copy-pasted from IBM Information center)

Please do not that. Link to articles in the Information Center, do not post their contents here wholesale.

The stage simply executes the stored procedure, if you want commits issued you'll need to code that into the procedure itself.

Sounds like you may need to look into a looping sequence job. Basically, a process would be used to generate a delimited list of the filenames to process and then the job you build to process them is 'looped'. Meaning it is run once for each filename and the filename is passed in as a job parameter....

Sorry, missed the fact that you were on Windows. Those instructions were UNIX specific... but you did miss a critical fact and that is that the command needs to be lauched from the DSEngine directory, not the bin directory. Which is why I specifically said to run "bin/uvsh" rather than &qu...

Search is your friend! One post with the answer to your question:

viewtopic.php?t=146513

What kind of joins are you doing - inner? Left/right/full outer?

Any chance the table it is reading or the selected result set is empty? A quick search turned up this: SQLError: rc = 100 (SQL_NO_DATA_FOUND)

That's because you didn't uncheck the "always open it with this" option when you told it to use Notepad. It then created that association between the dsx extension and notepad. Not really a DataStage question as that is pure Windows functionality but I really wouldn't worry about the icon,...

Noted.

Actually, it will never be executed due to the immediately preceeding call to DSLogFatal.

I was wondering if we were still on this topic. There's no need to effect any 'conversion' in this scenario that I can see.

NSIT-DVP-01 wrote:Should I chose Y instead?

There's no reason to ever answer 'Y'. And it wouldn't have asked the question if you were truly in the $DSEngine directory or one of the Project directories when you launched uvsh or dssh. Can you confirm exactly what steps you followed?

In 7.5 you can run the dsdlockd program with -p option. You need to be logged in with local Administrator privilege. I have just launched this to see what happens :) for the moment it is still running, I guess. It's a "deamon" which means it runs constantly. One of the configuration optio...

No worries, we good now.