DSXchange

Ray, Thanks for the response. I have resolved it by using the expression as below. If IsNull(lnk1.A) Then param_DefaultValue Else lnk1.A : ' - ' : lnk1.B : ' - ' : if nulltoempty(lnk1.C)="" then param_DefaultValue else Trimleadingtrailing(lnk1.C) Now job got compiled and result is as per t...

Ray, Thanks for the response It is working but i have one doubt in using this. we are getting data in column C with only spaces in them, so if i use the function as said then firstly spaces will not be considered as nulls, so those values will not be replaced with default parameter which is not corr...

I am trying to write the below derivation in the transformer for one of the field If IsNull(lnk1.A) Then param_DefaultValue Else lnk1.A : ' - ' : lnk1.B : ' - ' : NullToValue(Trimleadingtrailing(lnk1.C), param_DefaultValue) where lnk1---link A,B,C--input columns Param_DefaultValue---job parameter Wh...

It was showing progress. Then we opened a ticket with IBM and this is what they are suggesting. We are working on this and will let you know how it went. --------------------------- First make sure that you didn't include executables in your export - as all the jobs will need to be re-compiled anywa...

Hi !

I am trying to import a project (dsx file size 3.5 GB) in a fresh 8.1 installation and the import is running for last almost 4 days.

It used to take only about 6-8 hours in 7.5

Any ideas ?

Crash errors are not the easiest thing to track down as they're not like an Abort where it knows something is wrong and fails 'gracefully', they're more like the job just fell over dead with no time for any grace to it at all, including resetting the Job Status flag that Director shows you. Since y...

Hi There, I have a job sequence calling two server jobs, first one calls a stored proc and next one create two .txt files based on the data loaded by the proc. The file creation job is showing in running status but if i look at the monitor, it shows everything is finished. Also the job created two f...

The issue with the export was resolved by using a different client as suggested by IBM. So basically the manager client on one machine was giving all those errors that started this thread. We switched to a different machine for taking the export and it worked. Don't ask me how. After we took the exp...

thanks for your response chulett. For the version control project issue, we called up ibm tech support and they advised us to export the project and just import it into a new version control project. They say, that will somehow magically reduce the number of diretory entries. I don't understand how ...

Hi ! I am just providing some more info regarding the problem we are facing. This might be relevent. Our vesion control project has hit the AIX inode limit of 32767 directry entries in the project directory. we are unable to create any more directoy entries in the project directory. It manifests its...

Craig, Thanks for the reply. I ran the query said by you, i got the job names, but when i tried to open them, i am getting a error called "This item has no design time information" The project we are trying to export is version control project. so all the 3 jobs are the same but different ...

Hi, We were trying to do export full project from manager. while doing this we are geting the following errors 1.Cannot open executable job file RT_CONFIG9621 2.Cannot open executable job file RT_CONFIG9391 3.Cannot open executable job file RT_CONFIG9190 4.This item has no design time information an...

Thank you for the answer.

Hi Craig, Thanks for the reply. I would need to pass it as a bind variable only. the query I posted is for illustrative purpose only. For our real query we have to put a sql profile on the oracle side due to performance reasons; without the bind variable it would be a dba task every time this job is...

I have a job parameter PRC_GRP_CODE = 'GOLD'. We use data stage 7.5 on AIX 5.x and database is oracle 10g. I want to pass the job parameter in the where clause of a user defined sql (eg in bind variable :1). I know that if put it as #PRC_GRP_CDE# it will be sent to oracle as a string literal, but i ...