DSXchange

Yes I am getting this message every time when I runs. I converted this container to local then this warning is not coming. But I want it to be shared container.

I am getting the message while prompting for run "It is recommended you recompile the job in order to use the latest version of the Shared Container(s). Do you want to continue without recompiling the job?" I created the job from an existing job from production which is using a shared cont...

One thing to add .The whole SQL string is parametrized not just the Where clause.

Do we have any Environmental variable which will fix this.

Thank you for your suggestion.

We are using generic jobs. changing those will affect other jobs.

Not able to figure out how quotes are getting replaced and when we are giving '\' how it is working.

Single Quotes is getting replaced in ODBC stage Job structure is ODBC - transformer - file select query is like - select * from Sqlserver_tablename where condition - the whole query is passes from parameter #SQLQuery# #SQLQuery# is getting value from Trim(Convert(@FM," ",#Command_Execute.$...

Thanks mike for this idea ... it worked

qt_ky wrote:That may work. Just keep in mind the LOB settings in Connector stages. Sometimes you have to name or choose which columns are the LOB columns. It means having separate jobs unless you can parameterize that setting too (haven't tried it).

It worked ..Thanks a lot.

Thank you.

Let me try that possibility

I am getting the error message : Array size must be set to 1 while reading LOB's. My job is a generic job which runs on different metadata using schema file. Job structure is oracle table - transformer - sequential file . Currently array size is 2000 I changed to 1 and executed, it ran successfully....

Thank you for the response.

I think the special character is not hyphen it is longer than hyphen.
I am not able to find the ASCII value of that.
Can you please guide me to get that.

I've an issue in retrieval of data from sequential file . Characters hyphen '-' is loaded as inverted question mark. Job structure is reading data from sequential file and loads in to oracle table. While viewing data in sequential file hyphen '-' is viewed as inverted question mark. what kind of enc...

Hi Craig, Below is the routine which is hanging while trying to process huge data.PLease let us know if anything can be tuned to perform better for huge loads. DEL = "/" ; TOT = 0 FILENAME = argFileName IF FILENAME = "" OR FILENAME = @NULL THEN FILENAME = "INPUTFILE_FF"...

Hi, Its the routine which is hanging.We pass a file as a parameter to this routine. And what actually happens in Routine is ,it counts the total number of records present in the routine and the it also summates the last four digits of one column in that input file. Since past few months the amount o...

Hi, We are currently using server jobs of 7.5.2 version of Datastage. We have a routine which counts teh number of incoming records and also sums up the value present in the one of teh input column.It was working fine before.But since last few months,the job simply hangs. Can you please suggest us a...

Hi, Can I know what is being suggested in the above premium content. I have enrolled for the premium membership and made the payment but couldnt access the premium content even after 2 days of enrolement.Please let me know how many days would it take for me to get activated as premium member.As we a...