Search found 104 matches
- Thu Jun 13, 2019 2:46 pm
- Forum: General
- Topic: Field Function
- Replies: 2
- Views: 3291
Field Function
Hello, I have a command activity stage to get the job statistics as below DSHOME=`cat /.dshome`;. $DSHOME/dsenv; SRC_CNT=$($DSHOME/bin/dsjob -linkinfo DS_SANDBOX jb_SRC_TGT_Job_Extract ODBC_WELLHEADER_WELLBORE lnk_ODBC_Stage1 | awk 'NR>1{exit};1{print $5}'); TGT_CNT=$($DSHOME/bin/dsjob -linkinfo DS_...
- Wed Apr 10, 2019 7:38 am
- Forum: General
- Topic: Exec Command Activity
- Replies: 0
- Views: 2275
Exec Command Activity
Hello, In one of my Job, I have used a Exec command stage activity in which I am trying to capture the Job Statistics from the server as below DSHOME=`cat /.dshome`;. $DSHOME/dsenv; SRC_CNT=$($DSHOME/bin/dsjob -linkinfo MCB_IDAP_P jb_SRC_to_TGT_Norm_Load ODBC_Delta lnk_ODBC_Delta | awk 'NR>1{exit};1...
- Mon Feb 18, 2019 6:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC Stage Socket Error
- Replies: 6
- Views: 8042
- Thu Feb 14, 2019 8:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC Stage Socket Error
- Replies: 6
- Views: 8042
ODBC Stage Socket Error
Hello, I am using DataStage to read from Azure SQL Server and Writing into Azure Sql Server. During the process of reading and writing using ODBC connector Job is performing the CDC . For the High Data volume jobs, if the job runs for more than 30 minutes, I get this error message ODBC_Target,5: ODB...
- Sun May 27, 2018 1:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: pxbridge error
- Replies: 2
- Views: 4397
pxbridge error
Hello, We have a new Azure SQL database created for our project. After updating the ODBC.ini file and changing the DataStage environment variable to point to new Database, when I opened the ODBC connector stage property tab and hit test, "It shows connection successful" that means DataStag...
- Sun Feb 04, 2018 7:37 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Executing the IA rules outside the information analyzer
- Replies: 1
- Views: 11742
Executing the IA rules outside the information analyzer
Hello, Thanks a lot for the reply. We have another requirement of executing the IA rules outside the information analyzer either using Unix script or DataStage. The follow is as below Populate the Landing Area --> Execute the IA rules means we need to put the predecessor condition that once DataStag...
- Wed Jan 31, 2018 5:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Information Analyzer and DataStage Rules Integration
- Replies: 2
- Views: 2872
Information Analyzer and DataStage Rules Integration
Hello,
We have created few rules in Information Analyzer and when I am trying to execute those rules using DataStage, I am not able to view the rules in Data Rules.
Please guide.
Regards
Neeraj
We have created few rules in Information Analyzer and when I am trying to execute those rules using DataStage, I am not able to view the rules in Data Rules.
Please guide.
Regards
Neeraj
- Fri Nov 10, 2017 4:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC Connector Multiple update Queries
- Replies: 11
- Views: 11136
ODBC Connector Multiple update Queries
Hello, I am using ODBC connector stage to connect to Azure SQL Server and execute the 2 update statement in sequence as below: UPDATE HWP.WRK_VHEW_VOL SET EXP_DT = '2017-11-09' , STG_FL='D' FROM HWP.WRK_VHEW_VOL A WHERE EXISTS ( SELECT 1 FROM HWP.WRK_VHEW_VOL B WHERE A.ID=B.ID AND B.STG_FL='D' ) AND...
- Tue Oct 24, 2017 3:24 pm
- Forum: General
- Topic: dsexport command
- Replies: 2
- Views: 3098
dsexport command
Hello,
I am executing the dsexport.exe command from windows command prompt. During execution, it open up EXPORT PROGRESS window and at the end provide the list of components exported.
Is there anyway these message windows don't pop during export and import?
Regards
Neeraj
I am executing the dsexport.exe command from windows command prompt. During execution, it open up EXPORT PROGRESS window and at the end provide the list of components exported.
Is there anyway these message windows don't pop during export and import?
Regards
Neeraj
- Tue Oct 03, 2017 12:10 pm
- Forum: General
- Topic: DataStage and Visual Studio Team Services(VSTS)
- Replies: 1
- Views: 2920
DataStage and Visual Studio Team Services(VSTS)
Hello, We are currently using VSTS as the code repository as per the company standards. While looking at DSXchange, I have found a thread stating that we can use VSTS as a DataStage code repository and to do so first needs to download and install the eclipse TFS Plugin. I could not find any link exp...
- Tue Aug 11, 2015 11:53 am
- Forum: General
- Topic: MultiInstance Sequncer failing with Error code 255
- Replies: 19
- Views: 9186
- Tue Aug 11, 2015 8:25 am
- Forum: General
- Topic: MultiInstance Sequncer failing with Error code 255
- Replies: 19
- Views: 9186
Hello, I m trying to explain the issue once again and Hope it helps. I have a multi Instance Job. At same time 2 instances of the same job having different invocation ID are running in Parallel. Most of times, Jobs runs with Success i.e. from 20-July till today Job failed only once. My Analysis is:-...
- Mon Aug 10, 2015 11:24 am
- Forum: General
- Topic: MultiInstance Sequncer failing with Error code 255
- Replies: 19
- Views: 9186
- Wed Jul 22, 2015 2:17 pm
- Forum: General
- Topic: MultiInstance Sequncer failing with Error code 255
- Replies: 19
- Views: 9186
- Wed Jul 22, 2015 12:49 pm
- Forum: General
- Topic: MultiInstance Sequncer failing with Error code 255
- Replies: 19
- Views: 9186