DSXchange

I get the following error message while doing the import:

Error while creating job CW_GL_IT00003_J_DFPR_ACT_ENT
Error on CREATE.FILE command ()

Any idea why could it be?

Thanks and Regards,
-Sumit

Hi All, I have a dsx file which I am trying to import into DataStage 7.1 version. The import does not work and my guess is that it could be because the dsx file could be from a different version of DataStage. Is there any way to find out from which version of DataStage the dsx file was created? Rega...

Thanks guys for your suggestions. Right now I am going with routine option because soon we would be shifting from Windows to Unix.

Thanks,
-Sumit

Hi, I have a job that populates a sequential file from a table. The job is run once daily. Sequential file name is FEESAR_MMDDYY.txt, where MMDDYY should be dynamically assigned the date on which the job is run. For example, if the job runs today then the file name would be FEESAR_101504.txt. Tomorr...

If ( Iconv(Table.A[1,10],"DYMD") > Iconv(Lookup.Date1[1,10],"DYMD") and Iconv(Table.A[1,10],"DYMD")<Iconv(Lookup.Date2[1,10],"DYMD") ) then "Insert" else "Reject" Hi Preethi, I do not see anything wrong with this IF condition. I guess the ...

We figured out the problem. Since so many users were using this server we sometimes were trying to exceed the maximum number of files DataStage server can open at a time. The limit can be increased by increasing the Mfiles number. The other way to resolve this issue is to limit the number of users. ...

Mayank, I tried restarting the system but the problem still persists. It still behaves inconsistently - runs successfully at times and aborts at times. Regards, -Sumit Hi Sumit, I was also getting this problem. This is a problem with the Server machine. The Datastage server would need to be restarte...

There does not seem to be any problem with hash file name and the permissions because the job runs successfully at times. The disk space still available is close to 6 GB. I am creating the hash file using account. Hi, Have you tried using a different name? Does file with this name already exists? Ha...

The Job behaviour is actually unpredictable. At times it abort with the hash file creation error message and at times it runs successfully.

This means there is no problem with the job. What else could be the problem.

Thanks and Regards,
-Sumit

Hi All, I am facing a strange problem. I have a job that is creating a hash file. The job was working fine until yesterday but now it is aborting with the following error message: DSD.UVOpen Creating file "PS_GL_ACCOUNT_TBL_FIN" as Type 30. Unable to create operating system file "PS_G...

Thanks Craig. I have now converted it to a routine. Lets wait and see what Ray has to say on this.

Regards,
Sumit

Consider the below code for a routine: Ans = Field(Iconv(Arg1, "DMDY[2,2,2]"):"-":Status(),"-",2) It is just a single line code that accepts Arg1 as input. When I put Field(Iconv(Arg1, "DMDY[2,2,2]"):"-":Status(),"-",2) in transformer I get...

Hi, I wrote the following code in my transformer to validate Arg1, which is coming from the source: If Field(Iconv(Substrings(Arg1,5,6), "DMDY[2,2,2]"):"-":Status(),"-",2)=0 Then 'N' else 'Y' Sample data for Arg1: AAAA022802 AAAA022902 AAAA022904 The code works fine whe...

Thanks Craig. I just went through the Status() stuff and tried that. It works perfectly fine.

Regards,
Sumit

Hi All, I am getting a 6 digit integer as my input. I have to check if the input integer is a valid date in format MMDDYY. Here is what I do: I format the integer to get a character in the format MM/DD/YY and then use IConv on this to convert it to internal date. Arg = Substrings(Arg1,1,2):'/':Subst...