DSXchange

Hi sainath,
The parameters are hard-coded correctly. This problem occurs only when i export the job to the testing environment. It runs fine in development.

thanks,
arun.

Hi, I have a sequence which has triggers many jobs and sequence within it. The user name, password and system are all hard-coded for the jobs. During run time if i run the sequence by giving a different system name, the first sequence job fails, because it is not taking the new system name i gave bu...

I got the similar kind of error once, but couldnt solve it. I had to redo that particular job again and then it worked fine.

In Datastage7.5 there is the option of multiple job compile in the Tools menu.

No.. The Quality stage manager(qsrtmgr) is not running.... How do I resolve this... I recently asked my sys admin to add my project to the QS plug-in pack. Could there be a problem with that..

I am trying to use QS plug-in in one of my jobs. The job starts to run and never starts the Quality Stage job. I manually stop the job after a while.

Ur question is not very specific. But slowly changing dimensions can be done using a hashed-file ( look-up stage) or at the simplest level by just writing into a file(by setting the option to update).

The isnull function can be used to reject rows in the transformer. Use the IsNull() to reject rows which have null value. The syntax would be:

If IsNull(column_name) then REJECTED else Not(REJECTED).

Hi everyone, I am getting this error when i run my quality stage job. Error exec: /proj/dsadm/Ascential/QualityStage/bin/script_exec: !/bin/vsh: not found /proj/dsadm/Ascential/QualityStage/Projects/SRF519/Logs/DOWMATCH.Step004.log:ERROR: repgenc FAILED (4) Op Failed Step004 (4) EXITVAL=4 Would anyo...

Hi,

When I run a job which has a hashed file stage or a sorter stage it creates a lot of temporary files under the datastage home directory. How do i clear them. It takes up a lot of my disk space. Can i delete these files from the client side???

ThankYou.

Hi, If i have 3 columns with duplicate records in all 3 columns. how will I retrieve 1 record from column1 which has the max value in column2 which in turn has the max value in column3. column1 column2 column3 6 500 25 6 400 30 6 500 10 7 300 20 7 300 30 From this group of records i have to retrieve...

Hi, Is it possible to convert a sequential file into xml format inside datastage. I have this problem where I get a file in xml format i decrypt it in UNIX and then convert it into sequential file and use for my transformations. Is there an option of encrypting the results file back into xml file in...

Hello, We installed the new version of datastage 7.5 in our company last week. Today i installed my client components and recompiled all my jobs to test it again. But when i ran the job it is getting aborted. It says it is not able to connect to the database. BatchIdGen_Dev..Batch_ID_Incrementor: |B...