DSXchange

Thank you. Changing the ownership of one of the folders from individual user id to dsadm fixed the issue.

Can somebody please provide any input on this?

Hi All, I am getting an error 'Status code = -99 DSJE_REPERROR' when trying to run a script from command line. After logging into the server I sudo to dsadm, for running this script. I am able to run couple of other jobs in the same server the same way. Only a particular set of jobs are having this ...

Hi All, I have source query that needs to be run for multiple date values.There are 2 date fields that will keep changing. I need to find certain accounts that changed since 2016-01-01 to 2017-05-31 now (When we enter June that becomes 2016-01-01 to 2017-06-30. So the date range changes every month)...

Thanks Ray.

Mount point has been created. I also wanted to know if there is any other way other than Backup-delete-restore.

Appreciate both your input. Thank you.

Hi ,

I have my DS project created under /opt/IBM/InformationServer/Server/Projects. Can someone please tell me how to move the project from this folder to a different folder?

Thanks in Advance

Hi All, I have a set of clob data which I need to read and extract ID from. Data looks something like this Field1 Field2 TB_123 CLOB Data Tb_234 CLOB Data TB_567 CLOB Data TB_101 CLOB Data TB_589 CLOB Data Only in the first record (here TB_123) Id is from position 2 - position 8. In all the other re...

But I guess DSxchange users are not only from US

It would be great if someone can help me with a solution.

Thanks

Hi All, I have a requirement to do a range look up based on some reference values. The field from source is of type Char and values which I need to do a range look up (reference values) are of Varchar type. I tried to do a range lookup and its not returning any values. The output of range lookup goe...

Thanks everyone. We did uninstall and installed again.It works fine now.

Hi All, One of my friend is getting the below error, while installing Datastage 11.3 on Windows platform. com.ibm.is.install.exception.ActionException: CDIIN5075E: MKS installer: The OE installer process did not return success to nutinsInstallOe(). Can someone please help in resolving this. Apprecia...

Hi, I am trying to read a text file using execute command stage. I am calling the output of the execute command stage in a job activity stage below, using the below command FIELD(Exec_Command.$CommandOutput,@FM,1). Now the problem is , if the text file has Null values , I am getting the error "...

Thanks Craig. Mine is not a fixed length file. But its a fixed width column file. If any value is null, then nothing should be populated. Your comments made me check the APT_STRING_PADCHAR variable and I have changed it to 0x0 at job level (it was 0x20). Now the output file is getting populated corr...