DSXchange

Where is the TMPDIR pointing to? Is it a NFS file system?.

I believe the sqlldr will try to create pipes in this directory and if it is non-NFS then it would throw an error.

Resolved. The dataset was originally created using a different configuration file on different boxes where the scratch was defined. When we moved over to new boxes, the job tried to overwrite the existing dataset, but was unable to because of the mismatch in the config files. I manually went and del...

Resolved.

I had incorrectly pointed the TMPDIR to a NFS file system. That caused the SIGBUS error. I repointed it to a non-NFS file system that fixed the error.

Hello, I am getting the SIGBUS error in 7.5.1A. Based on a search from this forum, I tried the different options, but it still fails. -Re-running the job - Toggling the apt_monitor_time variable I have been using df -k in the scratch directories to track memory. How do I monitor all the memory a job...

Hi We have jobs failing in production because it is unable to create datasets based on the defined configuration file. We have a Datastage box and two DB2 boxes where the scratch space is defined. This is the first time we are running the jobs in this environment. Below is the error. /test/test.ds: ...

Hello, Is there anyway I can specify allow read access while using the load option in a DB2 Enterprise stage? I see it can specified in the DB2 Bulk load stage. If Db2 bulk load stage is the way to go for this option to be set then what would be the difference in using the DB2 bulk load stage vs Db2...

This issue has been discussed before. Please check this out.

viewtopic.php?t=128561&highlight=

Champa--

The code has to be something like this. Search for "D code" in the help guide. You will need to format the date appropriately.

Oconv(Iconv(date, "D"), "DWA")

But this option will run sequentially and will have a performance impact.

But ArndW, can't we use a BASIC transformer in a parallel job and use the iconv/oconv function in it?

I do not have a system to test this out.

Use a basic transformer in the job and use the iconv-oconv function to determine the day of the week.

Help guide on the iconv-oconv functions would tell you how to use them.

Absolutely.

I assume you want to convert a number into a string value in this format. You cannot have dashes in number fields.

Convert the number to string and use a substring function in your transformer..

substr(input_column,1,3):'-':substr(input_column,4,3):'-':substr(input_column,7,4)

This is how I passed the parameter.

pEmpId=1A\',\'23\',\'4ED

Select * from employee
where id in ('pEmpId')

Generated SQL:
Select * from employee
where id in ('1A','23','4ED')

[quote="dsuser_cai"]try using a back slash (\) before the single quote. for example i use it like this:
\'OD\' to specify 'OD'. i hoe this works for you.[/quote]

Thanks Chulett and dsuser_cai. It worked.

Well.. It doesn't work.. It removes the quotes in between..

It reads it as pEmpId in ('1A,23,4ED')

I need it as pEmpId in ('1A','23','4ED')