DSXchange

ArndW

What does that command do? Does it have any additional screen IO?

ArndW

Does "E:\putty\pscp" require any additional terminal input? Can you execute a simple "DIR" command without a problem?

ArndW

Using your "Output" variable:

Code: Select all

   FieldCount = DCOUNT(Output,@FM)
   FOR x = 1 TO FieldCount
      WorkValue = Output<x>
      AnotherWorkValue = FIELD(Output,@FM,x) ;** same result as previous line, just different syntax
   NEXT x

ArndW

Add a semicolon to the end of your SQL-flavor SELECT statement so that the engine knows which type of SELECT you mean. If you don't add the semicolon the engine will prompt for more code or a terminator and that is why your routine never returns.

ArndW

I am getting the same error message on my AIX as well - but I don't even have DSADM access. What user are you running this as - can you try it as root?

ArndW

The OBJIDNO is an I-type and is not part of the record or key. You cannot read it the way you want to, since the OBJIDNO is not unique and returns more than one record. You can use an execute to a SELECT statement and then process the returned list of record ids for that OBJIDNO.

ArndW

The parameters are not the issue in this case. Is the NtwxRunProcessMultipleTest routine present in your repository? If so, compile it. If not, then you have found your error as well.[/b]

ArndW

Add a semicolon to your select statement:

Code: Select all

Call DSExecute ("UV", "SELECT NAME FROM DS_JOBS WHERE NAME LIKE '%A%';", Output, SystemReturnCode)

ArndW

If you execute, from UNIX, the dsjob -report for your job this information will be listed. Alternatively you can use the DS/BASIC function such as DSGetJobInfo() to retrieve the information from inside a DataStage routine.

ArndW

Sreenivasulu,

DataStage is also supported on RedHat AS.

ArndW

Where (designer/director) and when (runtime,save,open,add) are you seeing the error message? If you save-as another name does the new one have the same error?

ArndW

Can you post your UNIX sort command line options?

ArndW

Your error is in a transform stage, most likely you are doing a mathematical derivation and your data is not numeric. Check your derivations and you will find the source of the problem. If you still can't find it, you can look at the BASIC source in the path shown in the error message around line 28...

ArndW

With PX jobs you have parallelism which might make jobs more complex (I'm not sure if you mean design-time run run-time complexity); with repartitioning and sorting. The same applies for aggregations and similar actions within the job. Job design spends a lot of time analyzing source data - that alw...

ArndW

Opdas,

if you can use a BASIC transform stage you can do the conversions using OCONV and ICONV functions; but this will slow a job down - if performance is a factor then you will need to write your own c++ function.

Search found 15603 matches