DSXchange

Hi Arnd, When i tried deleting the files using rm command in unix, i was getting the message permission denied. The execution permission is there for the Owner but not for the user and group. Yeah, I can view the data and access descriptor from datastage client. But Andw, u know for some of the cond...

Hi, When i try deleting dataset files using orchadmin, I am getting following error messages. can anyone throw me some light on that ? How can i overcome this? orchadmin delete /detld1/etl/ascential/Ascential/DataStage/Projects/CTI_London/IAM/staging/FXRate_20050525_129.ds ##I TFCN 000001 06:08:03(0...

Hi ,

I am very sorry for sending my previous mail. The same command is executing fine and I had a small typo error when i ran it lasttime.
Sorry onceagain to all.


cheers,
gopskrish

Hi, I can able to delete old files using unix command based on the number passed but when i replace it with orchadmin delete option it is not deleting files. Herewith I am attaching the command which i use for testing. Correct me if it is wrong. It is executing fine if the command is find /detld1/et...

Hi ArndW,

Thanks a lot for an immediate response. I will proceed accordingly. Your timely help is verymuch appreciated.

cheers,
gopskrish

Hi Ray,


Can you please help me out on how to find the location of datafile using the cat ? I am more of a beginner in Unix. Please share your thoughts.

Best Regards,
Gops

Hi Arnd,

Thanks a lot. I hope that i need administrative privilage to execute that piece of code. Correct me if i am wrong.

Best Regards,
Gops

Hi, Thanks a lot. I would like to know the equivalent commands in Datastage if i dont want to use Unix commands, and how to specify the value (number of days , like 7 in my case) for deletion or renaming. If u do have some scripts based on that, do share it with me so that i can see if i can impleme...

Hello Everybody, I want to rename and delete dataset files which are 7 days old ? Can i use Unix shell scripts to do that or Is there a better way of handling it ? I heard from one of my friend that Datastage automatically deletes the files in a periodical basis in the latest version. Is that true ?...

Hi Andw,

Yeah. I will do that. If u get more details on that do let me know.
Thanks for the immediate response.

cheers,
gopskrish

Hi, I am using sybase as my source and it is storing dates in integer format (internal to sybase). I want to pick up the value and then convert the same into date format using datastage. I hope there is a difference in the way sybase and datastage stores the first day (julian date). Now i want to co...

Sainath,

How to assign the output to a variable in a parameter file.
a= sort -r testfile |head -1
it is throwing the error.
I want to use the output in a parameter file.

cheers,
gops

Hi Sainath,

Thanks a lot.
If there are other ways of doing let me know.
I mean without parameter file and all.
I tried aggregator in parallel and I feel aggregator in parallel is very much confusing.
Let me know the other ways too.

Thanks for your info.

cheers,
gops

Hi DS users, I want to get max value from my last run sequential file for a field and i would like to assign the same to a variable in a parameter file so that when i run the job the nexttime, i will use that value in the source query where clause eg) where batch_id > #batchid# Assume i have loaded ...

Hi Guys,

I am using Sybase as the source and i would like to retrieve records where <date> = max(date) in the database.

How can i get that ?

Can anyone help me on this.

source sybase
job Parallel
tgt sequential

cheers,
gops