DSXchange

How many Sequential File Stages do you have in your job? Are you trying to read other files with different wild cards or names in the same job? I have seen this happen when there were multiple Sequential file stages within the same job and one of the file was not present in the directory the job wa...

You can promote that particular warning to Fatal Error message using Message handler. Or you can pre check the number or rows with the given file mask in unix and not to run the job at all. ... Thank you for the response...I understand what u are saying but I want to know if this can be handled usi...

I have a job the that uses file pattern to pick up all the files in a directory that has a specific file pattern.I want the job to fail when there is no file with that pattern but the job just shows a warning that there is no file and does not fail. Please let me know how I can make the job to fail....

Hi,

we are migrating from one server to another (bigger ). We have Xmeta in DB2 and our version is 8.1.0. Can a copy of XMETA suffice ? Do we have to do something on the Unix side apart from replicationg Users/ groups and Datastage engine install ?

Thx for ur help.

Hi, we are moving from one Unix installation to another (bigger server/more capacity). The software versions are not changing. How do we migrate the XMeta repository ? Is it advisable ? Can we just migrate the users/groups? We are using IIS internal registry and mapping credentials to a Unix ID . Th...

Even after converting into varchar...the leading zeros come up....is there any other way i cna get rid of the leading zeros

Hi, I am trying to remove the leading zeros in the decimal field in a sequential file stage. for example... if we have a value 000000000000000032.00 i want it to be changed as 32.00 . please let me know if there is any way i can do it . My input is a database and i am trying to put the data into a s...

chulett and kandyshandy,
Thanks for the quick responses! The requirement is to have the job proceed to the next job, weather it's an abort or a success.
Disabling the "Automatically handle activities that fail" option worked! Thank you!

I have created a DS job which completes with an error, and the error is allowed for this situation, but I'd like the stream to continue to the next job. Is there a way to change the JobStatus of a Job Activity from DSJS.RUNFAILED to DSJS.RUNOK? This job is also called from a sequence, so since the j...

We tried tweaking settings for the parameters SKIP_INDEX_MAINTENANCE and SKIP_UNUSABLE_INDEXES, with DIRECT=TRUE and PARALLEL=TRUE, and the job still completed with status of "Failed" for unusable indexes. The table that it is loading to is a range-partitioned table with two indexes. We cr...

I have created a DS job that will load data to an Oracle DB table. The SQL*LOAD options, $APT_ORACLE_LOAD_OPTIONS, are set to "OPTIONS(DIRECT=TRUE,PARALLEL=TRUE,SKIP_INDEX_MAINTENANCE=YES,SKIP_UNUSABLE_INDEXES=YES)" The data is being loaded to the table but the job completes with the statu...

In the Oracle Enterprise Stage can anyone tell me how to set UNRECOVERABLE mode so the setting is passed to the control file. You cannot set it at the options level: (DIRECT=TRUE, PARALLEL=FALSE, ... ) I have been trying different options with APT_ORA_WRITE_FILES and do not see any entries into the ...

Research SINGLEROW option in SQL*Loader manual. If it holds true for your db table, ask your IBM contact for SINGLEROW APT option fix. We had something similar, plus we were restricted to index storage size. The IBM team created a fix for us by supplying a patch that includes the SINGLEROW option in...

I do not know if this will help but I use the modulus statement in the 'WHERE' clause to simulate a parallel read. If I want 4 degrees of parallelism I create 4 Oracle stages and use the mod function in the 'WHERE' clause. However, you should use it with a numerical key. A hack I know but hey, it re...

The only issue I see with using an anonymous block command is that you are now putting this into sequential mode correct ?
I do not know if that is your desired result.
If so, I know that it works well.