DSXchange

Hi ,

I have a situation where i keep UpCase(String) in a table and get that value using script in datastage uservariable activity.But when i get that value in datastage it should give me the String value only instead of UpCase(String).

Is there any way we can acheive this in datastage.

Thanks

I am reading data using sequentila file and doing look up using hash file as reference.I need matched records and also unmatched from both the input and reference.

How can we do this in server job.Can any one please help me.

The below command gives only 3 mondays in january but actually we have 4 mondays. cal 1 2008 |cut -c 4-5 |grep "[0-9]" |wc -l You need to change the above command like below cal 1 2008 |cut -c 4-6 |grep "[0-9]" |wc -l cal 1 2008 |cut -c 4-6 |grep "[0-9]" |wc -l 4 Thanks

Search forum for DSX cutter.It will read the dsx file and split the dsx file in to separate jobs.

What is the last log event in the direcotor log.Can you see any thing like Parallel job reports successful completion.

Are you using insert rows with out clear option as the update action in the OCI stage.That is the reason you are commiting after the end of loading all records. If you are commiting after writing all records and if your job aborts after 2:30 hours then again you have to start from the begining (disa...

Then compare with space like below.
If (LinkName.ColumnName = " ") Then ... Else ..

Thanks

Check your JobMon app is running.If it is not running then you are not able to see performance statistics through director.

Thanks

Do you have any bitmap indexes on this table.If you have any please disable them before updating and also do proper partitining make sure all records with same key will be in the same partition.

I am using execute command activity in a job sequence to run a shell script.First argument is project id and the second parameter is password. In datastage I am using parameter called DBPasswd and type is encrypted and i am passign that parameter to the command line. In the job activity execute comm...

I am deleting my post from here

Can you pelase post your code.

You are executing os command and passing password through command line arguments.Even if you encrypt in data stage it will be displayed in the log.

Is there are any bitmap indexes enabled on that table.If you haveany bitpam indexes please make unusable before loading.

But you will get resource allocation probeem if you run infinite number of jobs at the same time.It depends on hardware,memory and other resources to run more jobs simultaneously.