DSXchange

Hi DS Gurus, We recently migated the jobs from DS 7.5 to DS 8.5. One of the job, which ran fine in 7.5, is failing in 8.5 with segmentation failure. When we have done the trouble shoot, after splitting the job in to 2 jobs then the job is working fine. We have observed that, one of the transformer i...

Hi DSGurus,

When we were tried to insert the VRACHAR data through DS 8.5 in the Terdata by using TD connector stage, we are gettigng the error UNTRANSLATABLE STRING .

Could you please through some light on this error?

Hi DS Gurus, We are recently migrated to 8.5 from 7.5, we are executing the couple of jobs which were aborted with the below errors and same jobs are working in 7.5. We have tried to debug the problem by enabling Trace Back mode and Disable combination options. It is always showing the same error. W...

Hi Folks, I know that, we can use the schema file if Sequential file is a source. I have a requirement, my source is DB2EE and Target is Sequential file. I have to extract full data from the source tables and needs to load in the file. I have around 100 tables with the same requirement. Instead of c...

Perhaps the problem is arising when DataStage is querying the data source to determine the data type - the executing user lacks SELECT privilege on the system table in which column information is stor ... Hi Ray, Thanks for the reply. But, I am able to execute the other jobs which have the simialr ...

How about getting rid of the warning to see if that might be triggering your problem? What data types do you have in your query (i.e., anything out of the ordinary char,varchar,number types)? Hi Arnd, Thanks for the reply. Warning is : SQLSTATE 01003: Null values were eliminated from the argument o...

Hi DSxians, I am getting a strange error in my DS Parallel job, I am trying to run a job in which DB2EE is the source stage...my log is showing DB2STAGE:Cannot Determine the type . Can anybody have idea about this error? I have tried to search here...I didn't find any post...When I have tried to exe...

Hi DSXians, I came up with a Brain Teaser on Datastage. This problem is bugging us, hope the Datastage world will help me. The Scenario is, my source data have a constrain on the Length of the String Field (10), if it crosses that limit, it is storing in a new row with the same primary keys by addin...

DSxians,

I have read about the Merge stage as Matching rows from Merge stage are consumed, where as it matching rows are Reusuable in Join and lookup? What does it mean ? I am not able to correlate these words ?
Can anybody explain me...

Thanks

Thanks Arnd & Ray for the response...

I got solution for this problem...after changing the Write mode option from APPEND to UPSERT....

Not sure reason for this...

Does any body have the light on this solution ....

Hi DSxians, I am trying to insert the data in a table by using DB2 EE stage. But, job is aborting with the below mentioned error : Internal Error: (group_.exportSize() <= dbquery->dataBufLength()): db2writeop.C: 985 Traceback: Could not obtain stack trace; check that 'dbx' and 'sed' are installed an...

Hi Dsxians, We are facing one strange issue in Ds Parallel 7.5, related to dataset. In one of our job, its a simple job extracting the data from DB2 API stage and loading into a dataset. With the first run, we got the warning When deleting data set PROD_DS, previous delete attempt not complete; remo...

Why not use APT_STRING_PAD_CHAR (0x20) in your extraction job (the one that loads the DataSet) also? That should make the filter on the CHAR(6) field work as you expect. Hi Aneesh, Thanks for your reply. Here my problem is,I can use APT_STRING_PAD_CHAR in my Extract. But, my extract dataset have be...

Hi All, What is the procedure to migrate message handler from Dev to Sys to UAT to PRD ? Intially, we used to copy the message handler files to Sys environment, where we used to edit the message handlers with the Sys related info. For example if a warning is specific to Dev value then We used to upd...

Hi All, We are facing a strange problem with APT_STRING_PADCHAR environment variable. I can say dangerous variable in DS. I can suggest handle with care. My Flow is : I am extracting the data by using DB2 API stage in Extract, Where I have one EMP CHAR(6) and DEPT VARCHAR(20) and I am extrcating int...