DSXchange

Hi, When I fire any query in DS Administrator I am getting some header in my output. Please see output below. Query: SELECT DISTINCT EVAL DS_JOBOBJECTS."INDEX(@RECORD,'\:vTableName:\',1) > 0", DS_JOBS.NAME AS JOB_NAME FMT '40L' FROM DS_JOBS,DS_JOBOBJECTS WHERE DS_JOBS.JOBNO = DS_JOBOBJECTS...

Thanks Ray, i tried it is working in windows server.

Hi Ray,

Thanks for the reply. Code that you have given can be run in UNIX server. But my server is WINDOWS.

Could you please tell me the command that can be executed from WINDOWS.

Thanks.

Hi,

Can anybody tell me how to run SELECT statement from command line?

SELECT NAME FROM DS_JOBS WHERE JOBTYPEIND='2'

I want to execute above query from command line and get all the sequence names list to a file.

Thanks.

Hi Ray, I fired "SELECT * FROM DS_JOBS", it retrieved only 4 columns (i.e. Job name, Description, No. and Category). I have not found Job type. I tried with below query, but it has trown error. SELECT NAME FROM DS_JOBS WHERE JOB_TYPE='Sequence' Error: Unexpected symbol "JOB_TYPE"...

Hi, I have following two requirements. 1) How to get only sequence name list from the project? 2) How to get the individual job name list which belongs to particular sequence. Actually, I have used "SELECT NAME FROM DS_JOBS", but it retrieves all the jobs plus sequences. But here I need to...

sorry, When I submit CHAR 8 is getting replaced

The above function is Ereplace(DSLink3.TimeSubGrp,CHAR(8),'',-1,1)

Hi, In one of my source file we are getting new line character at the end of each row. I have to take care this in Data Stage. I have used following fuction in derivation column, but new line character is not getting removed. Ereplace(DSLink3.Desc,CHAR(8),'',-1,1) I am trying to replace last digit i...

Hi,

The value gets stored in a hash file. I have used following update statement to reset the value from the DS Administrator.

UPDATE SDKSequences USING DICT VOC SET F1='1' WHERE @ID='fff'

Can I reset the value from the job sequence?

Thanks

Hi, Every load we need to update key management value so that it starts from 1. We know that we can update this value from command line from the DS Administrator. This is a manual step. But here we want to automate the job sequence in such a way that before running the job sequence, the sequence num...

Hi,

I have a job called JobSeq_Prod. How do I find out that in which folder the job is stored in project tree folder in Repository.

When I am trying to create new job with same name, it is not allowing me to create.

Can anybody help me how can I find the job?

Thanks..

Hi, I have one sequence which calls another 5 jobs. In sequence, till 3rd job it calls individual jobs and has run succesfully and 4th job calls a batch file. But 4th job is not running. It seems to be hanging. I tried stopping the sequence, but it is not stopping. Sequence has been running for more...

Hi,

Can you please let me know where do we get the Administrator commnad line queries. For ex: joblist, project list, SDK update etc.

And also what are the commnads we can fire from the Administrator command line and window command line.


Thanks.

One thing you can try is, drop the table and recreate the table with proper table space. Thanks..