DSXchange

Hi Ray I kinda made the third version of the job work by parameterzing the insert and the update statements. I am not sure how much value it adds to what i am doing though. So basically, i can trim values only if have the metadata for the oracle stage defined at design time and use the user generate...

Thank you so much Ray. I was able to use the schema file concept to load files. It works but only upto a point. I am not sure if it is because of the limitation of the tool or because of the limitation of my understanding :-) This is what i did. testfile1.dat --------------------- abc1, 38, 10000 bb...

Hi I need to load about 20-25 sequential files with different structures to load data into one oracle table. Later more sequential files may be added and they will all have different structures. Normally i would write a datastage job for each sequential file in which i will have - 1. a sequential fi...

This is not very obvious at first.... Open your DB2 Connector stage and look in the top left navigator. It should show one input link, the stage icon, and one reject link. Click on the reject link in the picture. It will highlight yellow and your tabs will change to Properties, Columns, Reject, Adv...

I'm updating a DB2 table using DB2 Connector stage. My stage has 1 input link. I want to capture records in to a sequential file. I have followed this thread and I did not find any reject tab. I see a broken link when I drag a output link from the stage and I know that means a reject link. I don't s...

hi ! thanks for your response. I just wanted to mention i am trying to install the windows client. I am not aware of any license file requirement for installing the client. Where is this license file supposed to be ? Other people in my group have simply been able to unzip the client installation zip...

Hi, I cannot install Datastage 8.1 because the screen Product Module and Component Selection does not show any products. Therefore I cannot select products for installation. When I try to select next without selecting products I get an error message from the installer saying 'You must select at leas...

I was able to do with the following command

sed -e 's!$FILE=/project/data/data.file.in.1.txt!$FILE=/ABC/data_ABC/data_ABC.file.in.2.txt! file.txt > Newfile.txt'

Thanks.

Since I don't see this as resolved...I'm continuing this thread.. Moderator: Sorry, no - you get your own post. If anyone wants to see "this thread" click here. Please let me know, how to solve the issue of extra comma on the end of the loop. problem is I have listed files in directory usi...

I encountered the same problem in one of my jobs and this is how i resolved it.... I have a fixed record length text file. This file needs to be FTP'd from from one server to the other. The first 9 characters are ID and the next 24 characters are dummy data to be ignored. In my job i was using the F...

I could create a value file (ValueFile.txt) which looks like ValueFile.txt $DB=XYZ $INPUTFILE=/project/data/data.file.in.1.txt $OUTPUTFILE=/project/data/data.file.txt What I would like to do is replace the $INPUTFILE with data.file.in.2.txt data.file.in.3.txt etc... My job design Routine Activity1--...

Ray, I understood the the concept of value files. Thank you. But I still can't pass the activity variable reference when setting the value of a parameter . The reason is I cannot view inividual parameters and their values of the parameter set with in the job tab of a job activity in v8.5. I believe ...

netgurutoo,

I didn't understand how to do below said statement.
"you can change this value file in your first job by writing to the file or over writting it."

I didn't quite get the whole thing. Can you please explain more...

Hi Ray,

The problem is I cannot view inividual parameters of the parameter set with in the job tab of a job activity in v8.5.

If that is poosible, as you said I could pass the activity variable reference when setting the value of a parameter.

Thanks.

Thanks Ray. Please let me know how to pass command output as a parameter in the parameter set. following is the error: ______________ job_name.Job_Activity_36.BeforeJob (ExecSH): Error when executing command: head -1 Execute_Command.$CommandOutput>/Directory/HDR_FILE.txt *** Output from command was:...