Search found 170 matches
- Fri Jul 10, 2009 5:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Reseting and Running a Job from Routine
- Replies: 3
- Views: 3450
Reseting and Running a Job from Routine
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...
- Fri Feb 06, 2009 4:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: OS/390 ODBC connection setup problems
- Replies: 10
- Views: 5804
- Mon Dec 29, 2008 2:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Procedure Date issue
- Replies: 1
- Views: 1877
Stored Procedure Date issue
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...
- Mon May 12, 2008 5:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Not able to import ODBC table definitions
- Replies: 3
- Views: 2823
- Thu Feb 16, 2006 1:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Routine - Code not visible to anybody
- Replies: 9
- Views: 6050
- Thu Feb 16, 2006 12:07 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Routine - Code not visible to anybody
- Replies: 9
- Views: 6050
- Thu Feb 16, 2006 12:04 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sqlldr Password visible at Unix level
- Replies: 9
- Views: 6985
- Thu Feb 16, 2006 12:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Routine - Code not visible to anybody
- Replies: 9
- Views: 6050
- Wed Feb 15, 2006 11:26 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Routine - Code not visible to anybody
- Replies: 9
- Views: 6050
Routine - Code not visible to anybody
Hi,
I have created a Routine, I want that the code should not be visible to anybody.
What is the method of doing this.
I have created a Routine, I want that the code should not be visible to anybody.
What is the method of doing this.
- Wed Feb 15, 2006 11:18 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sqlldr Password visible at Unix level
- Replies: 9
- Views: 6985
- Wed Feb 15, 2006 1:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sqlldr Password visible at Unix level
- Replies: 9
- Views: 6985
Sqlldr Password visible at Unix level
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...
- Sat Feb 11, 2006 2:19 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DS_JOBS Query
- Replies: 9
- Views: 6130
- Fri Feb 10, 2006 7:21 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DS_JOBS Query
- Replies: 9
- Views: 6130
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...
- Fri Feb 10, 2006 5:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DS_JOBS Query
- Replies: 9
- Views: 6130
- Fri Feb 10, 2006 5:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DS_JOBS Query
- Replies: 9
- Views: 6130
DS_JOBS Query
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...