Hi Frank,
Im using like below
#parmDataSource#
#parmUser#
#parmPassword#
Search found 75 matches
- Wed May 23, 2018 12:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parameterized password in Stored Procedure stage
- Replies: 12
- Views: 7363
- Wed May 23, 2018 10:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parameterized password in Stored Procedure stage
- Replies: 12
- Views: 7363
- Tue May 22, 2018 10:48 pm
- Forum: General
- Topic: Pass the User variable activity output to new sequence
- Replies: 3
- Views: 3019
- Tue May 22, 2018 10:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parameterized password in Stored Procedure stage
- Replies: 12
- Views: 7363
- Tue May 22, 2018 12:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parameterized password in Stored Procedure stage
- Replies: 12
- Views: 7363
Parameterized password in Stored Procedure stage
Hi,
I'm using Stored Procedure stage to call Oracle SP. In the data connection,
I'm able to pass the parameter for Data source and Username. However, I'm unable to pass the parameter for password as it accepts encrypted format.
Can you suggest the way to accept the parameter?
I'm using Stored Procedure stage to call Oracle SP. In the data connection,
I'm able to pass the parameter for Data source and Username. However, I'm unable to pass the parameter for password as it accepts encrypted format.
Can you suggest the way to accept the parameter?
- Tue May 22, 2018 12:06 pm
- Forum: General
- Topic: Pass the User variable activity output to new sequence
- Replies: 3
- Views: 3019
Pass the User variable activity output to new sequence
Hi, I have a sequence job1, where I called uservariable activity to receive a value from execute command activity and pass it to one of the job activities. I need the output of same uservariable activity to be used to sequence job2 as well. Is there anyway to be reused, instead of redesigning activi...
- Wed Mar 14, 2018 7:59 am
- Forum: General
- Topic: Client Repository structure in DS server
- Replies: 6
- Views: 4250
- Wed Mar 14, 2018 6:14 am
- Forum: General
- Topic: Client Repository structure in DS server
- Replies: 6
- Views: 4250
Client Repository structure in DS server
Can we get the Client Repository structure (Jobs folder structure) from DS server (unix)?
- Fri May 16, 2014 4:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: To handle empty file/only hd tr file
- Replies: 6
- Views: 4082
To handle empty file/only hd tr file
Hi, My source is fixed width file with below format. H00014700 Ddewuuwq T00014720 I have below scenarios for rejections. If input file falls under any one below, then I have to update another table with file name and reject reason 1. Empty file (zero rows) 2. Only header and trailer 3. Only Detail 4...
- Wed May 08, 2013 6:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: converting variable length to fixed length file
- Replies: 2
- Views: 1914
converting variable length to fixed length file
Hi, I have a file with variable length of records.Maximum length is 2000 bytes. I want to convert the file to fixed width. ie., I want to convert all the records to equal length of 2000 bytes by adding spaces. I have shell script for the above conversion, however, the converted file occupies more mo...
- Fri Dec 07, 2012 6:02 am
- Forum: General
- Topic: Not able to save jobs in same name
- Replies: 3
- Views: 2363
- Fri Dec 07, 2012 4:33 am
- Forum: General
- Topic: Not able to save jobs in same name
- Replies: 3
- Views: 2363
Not able to save jobs in same name
Hi,
I'm able to save 2 jobs with same name by changing the cases.
eg., job1- TEST, Job2- Test in test environment in DS8.5.
where as in UAT environment, I could not do the same.
Any idea?
Regards,
I'm able to save 2 jobs with same name by changing the cases.
eg., job1- TEST, Job2- Test in test environment in DS8.5.
where as in UAT environment, I could not do the same.
Any idea?
Regards,
- Thu Oct 11, 2012 1:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DRS stage in DS8.5
- Replies: 16
- Views: 13128
- Wed Oct 10, 2012 7:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DRS stage in DS8.5
- Replies: 16
- Views: 13128
My apology. Let me explain you clearly. My job is simple which extracts data from table A (SQL server DB) and do a look up with table B(TERADATA) and load it to Dataset. SQL server DB is connected through DRS stage and TERADATA is connected through TERA DATA stage. It works good, If I replace DRS st...
- Wed Oct 10, 2012 5:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DRS stage in DS8.5
- Replies: 16
- Views: 13128