DSXchange

HI

I also could not understand that the terminator is same as delimited.
Its 001. Can you send a sample data.

Regards
Sreeni

Hi, Can you send the sample code of how you are using the vb code with the Datastage template. Regards Sreeni Hi Sreeni, Based on the requirement. We can write the VB code which will take the template as the input and generate the DSX as output. For this we have to provide the configuration files su...

What is the terminating character used in the file

Regards
Sreeni

Looks strange. Will try this out and get back to you

Regards
Sreeni

We can check about the exact requirment with the guy who posted this message

Regards
Sreeni

HI There is a template feature as well where you can store the standard base designs of your project as a template Regards Sreeni Hi all! One of the features of Informatica's PowerMart (V5.x), was the rather simple ability to create jobs en masse to quickly be able to just do a raw copy of a databas...

HI I dont think its a good design to use a loop feature in sequencer to loop for each record. Looping in sequencer is generally used to loop to different subprocesses not to work on on record in a loop. Regards Sreeni quote="thebird"] You need to use the start Loop and end loop features in...

Hi

Ignoring Warnings is easy but if you have a standard restartability feature (doing truncation of data load in case of warning) then it could be a problem

Regards
Sreeni

Hi,

You need to use the start Loop and end loop features in a routine. I think
the DS Gurus are referring to using a routine to achieve this.

Regards
Sreeni

Hi, Definitely you can parameterize the schema name using the job paramters. Use #SCHEMA# in the paramter it will work Regards Sreeni Hi, I am using 'SQL Builder' from DB2/UDB API stage. But the problem is that I want to change the fully qualified name of the table, to include a Job Parameter. Eg. A...

Hi I also understand that you are setting the reject link to the target sql server Regards Sreeni Hi folks, I designed a datastage parallel job, source :- sequential File ---- Variable length --- delimiter Pipe Target :- sql server (DRS Stage) when i designed the job from sequential file to intermed...

Hi

The is a DSLinkRowCount function by which you can ignore the first 5 rows. Set DSLinkRowCount > 5.

Regards
Sreeni

Hi Kumar

I have no idea how to decide filename on runtime. Can you tell us ?

Regards
Sreeni

kumar_s wrote:If its about deciding filename on runtime, then YES, its possible on many ways.

Thanks Arnd

ArndW wrote:Sreenivasulu,

DataStage is also supported on RedHat AS.

HI Guys

Does Datastage 7.5 work on linux OS?

I have worked on Datastage 7 and it works on solaris,hp ux,aix,compaqtru64

Regards
Sreenivasulu