DSXchange

Hi I am loading metadata definitiion from the cobol copy to my Complex Flat File . The copbol copy book has a structure of one of the field as OCCURS ........ DEPENDING ON ..... INDEXED BY ..... My question is How to define this field? Should it be a GROUP. How to define the range in the Occurs cla...

Hi One thing I felt that I can ad is - If the SQL scrript called from a Unix shell run via Datastage Exec Activity fails- You need to have two things done to trap the SQL error and fail your shell> When connecting to Oracke use the following call. tab=`$ORACLE_HOME/bin/sqlplus -s /nolog <<EOF >>$LOG...

Hi I am loading metadata definitiion from the cobol copy to my Complex Flat File . The copbol copy book has a structure of one of the field as OCCURS ........ DEPENDING ON ..... INDEXED BY ..... My question is How to define this field? Should it be a GROUP. How to define the range in the Occurs clau...

Hi The Hashed file Stage , Read Cache size and Write Cache size from DataStage Administrator.... does it specify the max total size it can cache for all hash files in the project OR is it the value of each individual hash file cache size? Thanks It specify individual hash file size for Read and Wri...

Hi I am having a strange problem with Datastage :roll: In the job I am getting Input File as fixed width and in place of null we have blank. I generally TRIM then value and then check ISNULL - then handle it accordingly{ ISNULL(TRIM(LinkName.ColumnName)} But Datastage cannot understand that TRIM(&qu...

I suggest you search the forum for your topic. Generally we update the SDK sequence hashed file with a seperate job. The structure of the SDK Sequence is that it hads the Sequence name and the present value stored. So a Datastage job can take it in a Hash file and update it. Or run this command from...

Hi When I am running the Job control routine to test the Job control Routine to send mail I am getting the following error: CopyOfWL_SeqLoadRegistry_test_mail..JobControl (DSSendMail): The following tokens in the 'dssendmail_template.txt' file have not been set in the call to DSSendMail: %from%,%to...

Hi When I am running the Job control routine to test the Job control Routine to send mail I am getting the following error: CopyOfWL_SeqLoadRegistry_test_mail..JobControl (DSSendMail): The following tokens in the 'dssendmail_template.txt' file have not been set in the call to DSSendMail: %from%,%to%...

Hi can anybody please provide me the websites related to the datastage learning and other forums Thanks Ajay Well another forum and some documents on Datastage- the links are: Ascential Developer Net is a good one : It has a good forum (not as good as Dsxchange tough- personal opinion-no harm meant...

Hi can anybody please provide me the websites related to the datastage learning and other forums Thanks Ajay Well another forum and some documents on Datastage- the links are: Ascential Developer Net is a good one : http://developernet.ascential.com/home.php White paper on datastage: http://h71028....

Hi Another question: I saw that we have- #ExecuteActivityName.$CommandName# #ExecuteActivityName.$CommandOutput# #ExecuteActivityName.$ReturnValue# Can we somehow use them in the job control routine to send out success or failure email. Say I am using the folowing code to get the current job name fr...

seanc217 wrote:Hi thanks for the code.
Are you running in a Unix environment? or windows?

The issue I am having is in a windows environment. Even if I exit with an exit code it is not returning a non-zero code when using an execute command activity.

I am working in Unix environment.

A simple way is to have another shell to check the result of the first shell. If the result is created or valid meaning that it ran, then with conditions you can just mail out the status. I need it to be handled together with the datastage jobs.... Say I have the Job Sequencer as Shell--yes->DS job...

We are handling the same concept of using Execute activty to run the shell script- I was able to trap the error code of the Shell script and also SQL error: This is the code: the Return of status(SQL_STATUS=$?) at the end would help. If you dont have SQL it can also take any status coming out of the...

Hi I need to trap the status of execute Activity (shell script in my case) in case of failure and then mail out the status. Using Datastage Job control can we trap the Status of the Shell and the use DSSendMail to mail the log for that execute Activity. I think DSGetJobInfo would not get me the info...