DSXchange

Hi We are using SAP R/3 Pack ABAP 5.2.1 Realese with Parallel Job WITH DS 7.5.1 A we are getting the following error message when we connect DS Server from INDIA and run the SAP R/3 related Jobs and job fails. DataStage server and SAP Application Server are in Onsite we are connecting from Offshore ...

head -1 filename | cut -c1-10 if i use this script to read first 10 characters of a fixed width file, by executing the shell script file from filter command in sequential file i get "testmk..Sequential_File_0.DSLink2: nls_read_fixedwidth() - row 1, column Target, column unexpectedly ended by E...

did not find anything as given below,

chulett wrote:StageName.$Returnvalue if I remember correctly.

my whole question is how to capture that return value in further actions.....

Create a small job that selects COUNT(*) from source into a text file, then read this text file (Execute Command activity) then, depending on the result, either continue with regular processing or take the path described in the previous paragraph. i wonder how you can make Execute Command activity ...

when i do the above i get only

01410, 00000, "invalid ROWID"
// *Cause:
// *Action:

that is it or can i see causes,actions etc

can anyone throw somemore light

Thanx Alot

Hi we have a PX JOb where Source is a DataSet we are doing a Target Lookup on a Oracle Table the below ones are keys these are the same Keys in the Dataset to.. Oracle Keys LANG_ID Char(2) DECISION_CD Varchar(8) Dataset Keys LANG_ID CHAR(1) DECISION_CD CHAR(8) The problem is Lookup is Rejecting the ...

Hi

Where can we get Info on DataStage GRID Comptability.

Regards
Sendmk

if i write the below script in a file and execute it in filter command say "sh /home/kpraveen/test.sh" how can i parameterize the "filename" in the script "head -$(expr $(wc -l filename | awk '{ print $1 }') \- 1) filename | tail +2" so that it takes the file which is g...

head -$(expr $(wc -l filename | awk '{ print $1 }') \- 1) filename | tail +2

try this [/quote]

thx very much arndw

but

SELECT JOBID FROM DS_JOBS WHERE NAME = 'testsum'

gives

jobid.......

1 record listed.

i cant see the jobid, i wonder where can i see that information

i executed the below command in TCL but i get only an a blank screen with sql+ prompt

SELECT JOBID FROM DS_JOBS WHERE NAME = 'testsum' .

can anyone throw some light.

thx

kumar_s wrote:SELECT NAME FROM DS_JOBS WHERE jobid = 'nnn' .

so could u tell me where can i find the jobid.

thx

is jobid equal to pid



thx

head -$(expr $(wc -l | awk '{ print $1 }') \- 1) filename | tail +2

this would work