DSXchange

Here is the piece of code $INCLUDE DSINCLUDE JOBCONTROL.H JobName=Trim(Arg1) JobHandle = DSAttachJob (JobName, DSJ.ERRWARN) Status = DSGetJobInfo (JobHandle, DSJ.JOBSTATUS) If Status= DSJS.RUNFAILED or Status= DSJS.CRASHED THEN ErrCode=DSRunJob(JobHandle , DSJ.RUNRESET ) ErrCode=DSWaitForJob(JobHand...

What is QEWSD used for?

I wanted to know what is the significance of this value...

Hi, My job is executing one stored procedure (using stored procedure stage). this SP takes date as an input and date_out as an output. The procedure is running fine but the issue is that the output date is not correct. For eg, Its giving 01-JAN-2000 as an output where as the output should be 01/01/1...

I am also facing same issues.

Would you mind sharing sample entry so that I can make the changes accordingly...

Entry in uvodbc.config

PHDEVH
DBMSTYPE = ODBC
network = TCP/IP
service = PHDEVH
host = IPAddress

We are getting BCI error

Regards

Hi Anupam,
Try this link to create
Secure Routine


This is not the valid link.

Can you pls check abnd provide me the right one.

Can i have some way where in, The code tab is disabled.

-s does not work with sqlldr, it works with sqlplus.

Definately i will share the code to anyone who wants but can not share in public. Who so ever wants the logic should send PM to me. I hope you guys understand, its security issues....

Actually, the code which i have written should not be visible to any developers and operation members.

Nothing related with Money Issues.

Have i told you that I am back in Reliance Mumbai.

Hi,

I have created a Routine, I want that the code should not be visible to anybody.

What is the method of doing this.

It was not solved fully. If somebody execute 'ps -ef | grep sqlldr' then the password was visible.....

Anyways, now i have solved it.

Thanks all of you all....

Hi, I am executing sqlldr and do not want my password to be displayed. I have defined an environment variable and passing it to 1 routine and call dsloginfo. My password is not getting displayed anywhere in DataStage. My problem is to hide the password from unix level also. When my Job is running, i...

Thanks a lot everyone, I got it resoolved. In my query i Restricted the lenght of Job Name and Category each to 30 and then took the substrings out of the fetched record.

Thanks

This is my code. I am still unable to extract the values of Job name and Category. $INCLUDE DSINCLUDE JOBCONTROL.H 0 Ans=0 JobName='J1AaabXfm' Command ='SELECT NAME, CATEGORY FROM DS_JOBS WHERE NAME=':SQUOTE(JobName):';' Call DSExecute('UV', Command, Output, SystemReturnCode) NoOfMessage = DCount(Ou...

I am getting the JobName and Category name in Output when executing the UV command. I want to store these 2 in 2 different variables.

How to separte these 2 fields and equate them to variables ?

Hi, I am executing one query from Routine. The Query is "SELECT NAME,CATEGORY FROM DS_JOBS WHERE CATEGORY LIKE ='AAB%'" The output is shown below : Result = Job name............ Category............ J1AaabXfm AAB\S1Lbw 1 records listed. I am unable to capture the Category name. I want to c...