DSXchange

Thanks Ray, When we check the child Job we are able to seen the status =1 (Finished OK). In the parent job (Server Job), we call 1 by 1 (child Job). This Child Job there is no mapping instead we are writing the scripts like check the file name if it is Ok. Then generate the output file with Header a...

Dear Guru's, Recently, some of the jobs which is running through the control jobs not getting the status of the child Jobs even though the child job completed. Some times we are not able to open the child job category folder. Once we select the category folder it hangs. We are forced to kill the Dat...

Thanks a lot ArndW & RAY & kcbland.

Finally it worked.

Thanks with Regards

Thanks ArndW,

I correct it. But, the problem is in this line.

"EXECUTE 'SH -c "':Command:'"' CAPTURING ScreenIO RETURNING ErrorCode"

How can I change it for Window.

Please help.

Thanks a lot for your help to solve my problem.

Thanks with Regards,

Dear ArndW, I created the routine but when I am testing the routine I am getting the following error message. "DSLogWarn called from : ExecuteSQL Message to be logged is... > Warning, SQL command returned "This command is not available on this platform > ", error -1 Result = -1 This c...

Dear Ray, I even changed as per your advice. If you see the Sql Statement I mention the table name wrong. So I expect the return value -1. Please see the log. Lf = Char(10) CrLf = char(13):Char(10) *CrLf = char(59) *RoutineName = "ExecuteSQL" SqlStatement = " select ofdm_ods.ofdm_get_...

Actually, I want to execute a function using the Script and get the return value. If the SQL is execute correctly the I will mark the record is send successfully. Else I write the Record to the rejection file for the investication. Please help how to execute and get the value. For Example I am writi...

Dear Guru's,

Please help me if any one knows how to connect ORACLE and execute the procedure and get the return value of the procedure by writing the script.

Thanks with Regards,

Thiruma

Dear Kumar,

Did you moved all the job you are calling in production. I think the Job you are trying to call in not in complied or executable state. Or the job is not available. Otherwise the Sequence Job (Control Job) will not abort.

Mr. Ray, I checked on this course. But, currently I am using the Data stage 7.x even for real time like ( Web to ETL to WISI "Mainframe") using the Normal Data Server license I created the Job and it is triggered from WEB Application. And all my Jobs are re-runnable and it is triggered fro...

Looking for advance training in Data Stage. Please specify If any one know about it. And also please provide me the training code & location.

Dear jhmckeever, Ray & Eostic, Thanks a lot for the Information. Actually, some one asked me is it possible to use ETL for socket connectivity. We like to kick the cloverleaf out and instead we like to use the Data Stage & Tuxedo (unix) instead. Once again thanks for the useful information. ...

Hi Guru's,

Does ETL able to handle TCP Socket connectivity? Wherein it can send request message and receive reply (or vise versa) using TCP Socket.

If yes, can any one give me some sample.


Thanks in advance.

Please try this format. Ask the mainframe people to give it in binary format. Then in your meta data structure, you mark the fields that are having date or decimal to comp3. And try it. If it is not working please send me your COBOL file structure in a text file.

Best Regards,

Dear Fernando,

For the same version the space works for us.