DSXchange

ArndW wrote:After the job aborts with 139, do a reset in the director and see if you get a message titled "From previous run..."

No ArndW,
There is no message like that. It simply says
Resetting Job test_copy_table.
Job test_copy_table has been reset.

Thanks
Kavuri

Further, I am seeing the following info when I run the job. Contents of phantom output file => RT_SC609/OshExecuter.sh: line 20: 31321 Segmentation fault (core dumped) $APT_ORCHHOME/bin/osh "$@" -f $oshscript >$oshpipe 2>&1 Parallel job reports failure (code 139) Job test_copy_table ab...

Here are answers to the questions. ArndW, Do you have a SELECT clause? If yes, does it return data when used in your favorite SQL tool? I am able to select the data from command prompt. What happens if you run the job instead of using view-data? That gave me the following error. Parallel job reports...

Here are answers to the questions. ArndW, Do you have a SELECT clause? If yes, does it return data when used in your favorite SQL tool? I am able to select the data from command prompt. What happens if you run the job instead of using view-data? That gave me the following error. Parallel job reports...

Hi, Below is the message I am getting. No rows were returned from the View Data Server Command. Would you like to view the command's output? If I say yes, following message appears. ##I TFCN 000001 16:17:10(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5.2 Copyright (c) 2004, 1997...

Thanks Ray, I tried ODBC Enterprise stage. Its working. But able to connect to one Netezza box but not to other one ( I mean I am having 2 Netezza boxes or 2 Database servers both Netezza). Similarly I checked from another Linux server to connect to both the Database servers, but unable to connect. ...

Hi, I am using a simple job to read data from Netezza database and have a copy stage and load into a different Netezza database. To read from Netezza database in the first stage I am using ODBC Enterprise stage. I am getting the following error when I run the job. Parallel job reports failure (code ...

Hi,
I am using Netezza_Enterprise_7 stage.

I want to extract data from a Netezza Table and load into a flat file. I am unable to extract data from table. Even design itself is not permitting.

Thanks
Bhargava

Hi, Till now I am able to insert some data into Netezza database. Just today I am trying to extract( query) some data from Netezza in DataStage. But I am getting following error. (40822) The source stage does not support output links. Please let me know the issue. I am even unable to output link als...

Implemented the above logic and it works fine for all months expect for this 2007-09-01 month.
Do i have to change my logic...

Hi, I am passing a text and seperating fields based on location as shown below. But as my string consists of decimal values, I am trying to convert these by using stringtodecimal function. Its resulting 00000.00 as output for that field. Let me give more details as below. StringToDecimal(DSLink3.INP...

Thanks Ray, Now what should I do? Do I need to put it resolved?

Thanks
Kavuri

Hi,
Are there any best practices guide?

Thanks
Kavuri

Hi, here in our project we are extracting data from zip files and then validating the data then actually we need to write this data into Netezza database. But in the jobs already developed what they have done is they are writing data into a sequential file and the in another job they are writing fro...

As Maveric said the previous code is giving error. So I tried by writing shell script to get the information. #!/bin/ksh . /opt/IBM/Ascential/DataStage/DSEngine/dsenv ProjectName=InStore JobName=test StageName=tran ORGCODE=$1 FILEPATH=$2 link=link filename=filename i=1 for i in 1 2 3 4 do link=link$...