DSXchange

Hi, I am triggering a script with different parameters, that triggers a datastage Parallel job with different instances at same time. Sometimes they are running as expected and some times jobs are failing with the following error: ERROR: Failed to lock job Status code = -10 DSJE_JOBLOCKED When I re-...

I will try that. But before I just tried various options with ODBC Connector. Can you please help in figuring out with ODBC stage.

Hi, I am trying to read a SQL Server Stored Procedure in the following way in ODBC Connector Stage: DECLARE @TEST int Exec dbo.spValidateLoadProcess 'xyztable', @TEST OUTPUT SELECT @TEST abc Then I am getting an error as Null Arguement:pDataSetDef Can anyone help me in accessing this procedure. If I...

Use the given expression below. It will work.

If svMatchCheck = 1 Then
(svGroupRecordIdx + 1)
Else
1

By default, when running a job, InfoSphere DataStage stores state information in the current
working directory. This value will be Empty by default. We have to use APT_CHECKPOINT_DIR to specify another directory.

I have directly executed at Client tier.

When I give that command, a popup window prompting for user id, password and project is getting enabled.

I don't want to re-enter it again. Datastage version is 8.5v and running the command from Windows.

I want to export job with executable individually at command line. I am using dsexport.exe command, it is prompting to a window where in we need to reenter the user id , password and project details again. I don't want any another window to be prompted. Directly using a single command I need the exp...

Hi, I am using a sequence job which has one parallel job. APT CONFIG FILE at project level is set to 2 nodes. In sequence job, I have added APT CONFIG FILE parameter and assigned 4 node configuration file to it. But my parallel job present in the sequence is running on 2 nodes only. I want to run th...

No Sura... this is not working...

Hi,

My requirement is to replace | with |"

i tried with convert('|','|"', inputcolumn). But this doesn't solve the requirement.

Please suggest me how to solve this. My output is one shared container for which i have to send the data in this format.

only right side... empty fields needs to be trimmed

my output should for the corresponding inputs should be

abc|"1234|"xyz|"1|"|" --- abc|"1234|"xyz|"1
xyz|"3244|"342|"|"|" --- xyz|"3244|"342

Hi, I have my source record as abc|"1234|"xyz|"1|"|" xyz|"3244|"342|"|"|" I have Strip |" at the end of each record. How I can accomplish removing quote characters... I tried with trim function and mentioned |" as delimiter field but it was...

permission to the project is 775.

The command used is

dsjob -run <project name> <job name>

project name and job name are correctly given**

i have run the dsenv file from DSEngine path using . ./dsenv command and then used this dsjob command...