DSXchange

Hi, Please find the steps below to unlock the job which has been locked. Please be aware that no one else is using the job. 1. Log on to DataStage Telnet Server (e.g. TELNET <ServerIP> ) 2. Logon to Server using Username and password. 3. Type LIST.READU EVERY. Check for the job which has been locked...

Hi,

Actually the code belongs to the GetJobReport built in routine of DataStage. I have modified it to generate log of the job into a text file. Ray & Chulett, thanks for the advice & comments.

Hi, Sorry, forgot to customize the code as per the requirement. Call the routine from the Job Properties window and just specify the Directory Name where to create the log file in the Input Value field. Execute the job, it will create log of the job in the text file. Please find the updated code bel...

Hi, Please find the Before/After Subroutine Code below. This routine will direct the log of the log into a text file. Call this routine in the Job Properties window and specify the type of the file (1 for text file ) and the directory in the Input Value field. It writes the log of that job under the...

If u need, send me your mail id. I'll send the patch to u.

Can u please tell me how to change default date format when the NLS option is enabled. I just want to change the time from 24 hour format to 12 hour format.

Hi,

Otherwise please tell me how to disable the NLS settings for a particular project.

Hi ArndW, The routine works fine in DS 7.51 with NLS version for the following codes: Ans = Iconv(Arg1[1,8], "DYMD") Or Ans = Iconv(Arg1[1,8], "D ") But if I want to use the same below code in both the versions, can you please tell me what I need to do. Ans = Iconv(Arg1[1,8], &qu...

Hi,

Examples:

DS 7.1 without NLS

Value Result
20060902 00:00:00.000 14125
19671231 00:00:00.000 0

DS 7.5 with NLS

Value Result
20060902 00:00:00.000 -389172
19671231 00:00:00.000 Nothing

Hi,

I have one routine with the below code.

Ans = Iconv(Arg1[1,8], "D")

The same routine with same passing values is returning different results on DataStage 7.1 without NLS and DataStage 7.5 with NLS enabled is giving different results. Please advice how to overcome this issue.

Thanks Kim.

The information was very useful.

Ray,

I was working on the dscmdexport command. In the meanwhile I needed to export one job. So I used the Manager, there I unchecked the XML option as I wanted it in dsx format. After I resumed to dscmdexport issue, then it was working properly. So I thought this may be the issue.

Thanks to all!

I found the issue regarding this. This is the problem with Manager. I have used the Manager for exporting jobs as XML Document. After that if u try to run from the Command line which exports as dsx file, we'll get this replace file window. Before running the dscmdexport command, Go into the 'Export ...

That's not working!

Hi,

The problem is not with the syntax. When it executes, its asking for to replace the existing file. When I say yes, it's exporting all the jobs to that file. The problem is there is no file in that path for which I am exporting the project.