DSXchange

Hi,

What is the syntax to append to a column using the uv SQL, like we can do for other databases using sql?

Thanks,

Hi Sainath,

Can you please elaborate?

Hi All,

I want to append "," at the end of each of the job names outputed by the command below.

$ $DSHOME/bin/uv "Select NAME from DS_JOBS";

Thank You,

For Projects:

dsjob -lprojects

For Categories:

select DISTINCT(CATEGORY) from DS_JOBS;

Hope this helps

Sunshine

Hi, This what I amm trying to do but not able to write to text file. :( cd ../DSEngine/bin $ uv > Logto LETS_A > SELECT * FROM DS_JOBS > /home/dsadm/trial1.txt; DataStage/SQL: syntax error. Unexpected symbol. Token was ">". Scanned command was FROM DS_JOBS > Please tell me what am I doing ...

Hi,

select * from ds_jobs where category='ELDM\DIMENSIONS'; >/HOME/USER6/TRIAL.TXT

It lists down 8 records.
It does not write to the txt file.

Thanks,
Sunshine

Hi Ashwin,

Thanks for the reply.

I am able to execute the command and see the list of jobs but I am still not able to capture the list in a text file.

It executes the command but does not write to the text file

Thanks,
Sunshine

Hi Friends, I would like to get the list of jobs belonging to a category in a text file. I am aware of SELECT * FROM DS_JOBS where CATEGORY='' I tried executing the command in uv and got an error saying DS_JOBS table does not exist. Can I execute this command in uv? 1) If yes then what am I doing wr...

Hi Hexa,

You can load the data using the Upsert method.

Hi snassimr, Please refer to the rowmerge.pdf and rowspilt.pdf for more details Also in short, Row Merger reads data one row at a time from an input link. It merges all the columns into a single string of a specified format. It then writes the string on a given column of the output link. The stage c...

Try

select A from Hash_Booking;

Lets us know the result

Hi, This question was asked to me by a collegue who attended an interview, According to me the Interviewer is checking more of the interviewee's presence of mind rather then anything else, as the question has very little to do with the skills in developing jobs through DataStage Anyways I would have...

Hi,

This is an Interview Question

Is DataStage a Compiler or an Interpreter? Explain why?

Kindly guide us

Thank You

I came across a strange scenario at work today, A job containing a FILTER stage completed successfully but the performance statistics did not change niether did links turn green but I had got the expected output. :shock: After checking the log I discovered that though the job had completed successfu...

Hi,

Please refer to the below post for more answers

viewtopic.php?t=92746&highlight=duplicate

Hope this helps