DSXchange

Hi

1.I have parameter file that has DSN,usrid passowrd &35 other parameters.My requirement is my job should use corresponding variable from param file..how should i go about this.

2.XML input/XML outpt -I could not even place these components in my designer window it throws an err.

plz help

Does it mean each and evry time i create a project we have seperate repository

sorry..It was going going to error page so I was not able to vie your reply

Can I have one repository for dev one for prod

Thanks for you reply.My idea is to ve one for development one for production...with same server ...datastage engine

Thanks for you reply.My idea is to ve one for development one for production...with same server ...datastage engine

Hi

Is it possible to create multiple repository.How do we do it

Thanks

Key column is declared and they are of integer type

still it gives the err

Key column is declared and they are of integer type

still it gives the err

Hi

I have a Seq file,Lookup fileset and lookup component.When I try to map lookup fileset with look up component based on key.It gives an error

"Key expressions cannot be set on Key columns.Connected stage is used for lookup"

Please help

Thanks

Hi All

Is it possible to access shell variable within job.if the output from my shell script is "$a","$b".Within job can i access it and pass it a column or do some transformations.(without using DSExecute)

Thanks

Hi Please find below my requirement replace("man on the moon", "m[aeiou]+n", "X") - Output should be "X on the X" m[a e i ou ]+n is the substring to be raplaced i.e m can be followed by a or i or e ... Replace is my userdefined routine. Ex:2 Similarly i should...

Maveric wrote:Not in one job but 2 jobs or 3 jobs if you want C to D as well. Create the jobs and then control them from the sequence. Triggering the second job once the first job is completed and so on.

I want that to be done in 1 job? Is it possible

Hi

Is it possible to obtain target based loading in Datastage.
For ex:

I have one job in which i perform two loads

1.From Table A to Table B

2.From Table B to Table C or table c to D

Point 2 should start after point 1 is completed....Is it there any property to set that

Thanks

Hi

Is there any in built function to check regular exp like

[a-z] +,[a e i o u]+, [0-9]+ and so on...Or should we write user defined routines

Thanks