are you trying to create some kind of sequence by getting a count from the hash file and add the row number. in such how arre you getting the count from the hash file to transformer. Check the from hash file as soon as you read it by using a peek stage. If you are getting avalid value then check the...
Hi SNassimR, In DataStage Director from the menu Job -> Cleanup Resources you get a window with two text areas. Choose "show all jobs". in under both the screens. Yhis will show you all the job locks and process Id. Check for the Job name and note down the process id. Now go to unix prompt...
Hi VJ, Above suggestions hold good if you have used the Null field property while writing to the file. Otherwise you will not be able to read this record. Actually Nulls do exist in Sequential files but these values are not interpreted correctly. To avoid any such prcarious situation, use Null field...
As elavenil suggested when you export the file you get such errors when as process is not terminated. If there is any issue during export DataStage writes the error message to dsx file which is happening in your case. The object file created by DataStage on compilation of the job. All teh libraries ...
You can achieve this functionality in a routine by using DSExecute and all the logic embedded inthe Code. Even Job cintrol Code would be another option.
Hi Ray, You quoted If you have DataStage you already have the compiler. But it should be invoked from within the dssh environment. The UniVerse BASIC compiler should be invoked from within the uvsh environment. can you just give a snippet to compile a BASIC program . Are BASIC program different from...
Simplest way would be to go to DataStage Manager->Shared Containers->sharedcontainer then do usage analysis.
It lists down all the Jobs where in this Shared container is used.
Hi
Is there any posibility to execute routines through unix scripts?
If so how can this be achieved ?
When we write routines where does DataStage store these routines and in what form does it store. Can we access this Data Stage Repository?
Hi To get the line count of a file in a Routine you can use this piece of code. Call DSExecute("UNIX","wc -l ":strFileName,Output,SystemReturnCode) If Output=0 Then -- logic to be implemented End You can read a Job parameter from the routine and assign the variable strFileName th...