DSXchange

DSCMDEXPORT is better to export the whole project, it includes the executables also,

Search for the keywords dsexport , dsimport. You will find lot of posts.

Yes, we can do that Call DSExecute("NT","C:\Progra~1\Ascential\DataStage7.5\DSExport.exe /U=Admin /P=***** /H=Hostname /JOB= TestJob PROJECTNAME c:\aa.dsx",Abc,Abcd) Call DSExecute("NT","C:\Progra~1\Ascential\DataStage7.5\DSExport.exe /U=Admin /P=***** /H=Hostname ...

I am trying to create a server job with two streams (Incremental and Destructive). I am having a Jobparameter which will tell whether it is Incremental Load or Destructive Load. So From a Transformer I am having two links, I put the constraint for Link1 as Incremental and for the Second Link , I hav...

Ray,

Are you still taking these type of classes. If yes, when and where will be next class? Is it a online class or is it a Class room type of training.

For TEXT datatype, we are using Varchar(2000) and the jobs are running fine.

we also had a problem when using MSSQL Server 2005 as Metadata Server, but it is working fine with DB2 as metadata server. I hope may be it is because of licensing problems, Not Sure about it.

What will be the maximum value (in length), i can store in Hashed file for a particular column? I am thinking of storing some appended values in a Hashed File, Something like KeyCol NonKeyCol k1 AA|BB|CC|DD|EE K2 AA|BB|CC|DD|EE Here the length of the Non key column will change based upon the number ...

Ray, Thanks for guiding me to the right path. I have wrote a routine based on some previous posts.

Now the job is working fine as per my requirement. The question which comes to my mind is , As this is undocumented method, whether it will work in Datastage 8.

Thanks
Anand

I want to calculate CRC value for dynamic columns, we are in a type of product development, so it is upto customer to choose the columns, he wants to track the changes. So i thought of maintaing something like parameter file, and define the columns there. And while running the job, i want to read th...

If you know, whether the incoming row is Insert or update, then for the Insert Target Stage, Set target action as "Insert New Rows only" and for the Update Target Stage , set the target action as "Update Existing rows only". Because the target action "Insert or Update" ...

There are some other ways to find the information you want. Kim Duke has posted lot of queries like this. one of them are SELECT DS_JOBS.NAME AS JOB_NAME, DS_JOBS.CATEGORY, DS_JOBOBJECTS.NAME AS OBJECT_NAME, DS_JOBOBJECTS.OLETYPE, EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),'YOURTABLENAME',1) ...

Write the Output to a Sequential File and Check the data, If you get the complete set of data, then your job is working fine.

In this case Check in the Database whether any triggers or constraint is there.

Thanks
Anand

Any updates on Creating the Column name dynamically?

I just created a test job, which will read from a CSV file and load it to a SQL Server target. I have used DRS as Target stage. First I have inserted all the records to the target by selecting "Insert rows without clearing". Then I made the target update action as "User-Defined Sql' a...