DSXchange

AND ID = ORCHESTRATE.ID

mdbatra wrote:Is there any way that we can use the command line to delete a particular category and also compile(after the import is done).

No.

This is not something that the parallel Sequential File stage does well. Read the entire line as a single VarChar field, then use a Transformer stage both to parse and to handle the double quote characters appropriately. This is a task that can much more easily be handled by a server Sequential File...

Set up a job parameter. Have Autosys supply the value for that parameter as part of the dsjob command line.

Search DSXchange for "vertical pivot"to get details of techniques. The most usual technique in parallel jobs involves Transformer and Remove Duplicates stage (given that you're on version 8.1).

Look very carefully at the routine code. Does it use Open or OpenPath? What does that tell you?

"Doesn't work" doesn't help.

What error is thrown?

I suspect that the parent directory for "perl" is not in your command search list (that is, the PATH environment variable).

OK, now let's see you profile compliance with data rules "with one click in Excel".

That statement's only limiting the types of Linux. I can inform you that grid support exists on Solaris, using Sun Grid Manager to manage the load. Grid support also exists on AIX, so I assume it would be available on HP-UX. They may have "native" grid management software, or you could pos...

Take a look at the sample code Routines\Built-In\Utilities\DSSendMailTester and DSSentMailAttachmentTester to find out how to use a routine. You could invoke this routine from a Transformer stage or, with a bit of re-work, as an after-job or after-stage subroutine.

Learn the effect of the following special characters in the operating system shell:

• &
  
  ;
  
  |
  
  >
  
  <
  
  &&
  
  ||

You will then understand what is happening. Then learn about "escaping" and other techniques for bypassing the behaviour of these special shell characters.

The error message is complaining about "DEFN_NUM". Maybe you left an underscore out of "JOB_DEFN_NUM".

Excel also stores dates in a numeric format. You have to specify the cell format to get it to display (or dump) in any other format.

Date data type will be converted to an internal format when processed by the import operator. How are you determining that the value is 40240? (Don't believe everything you read in newspapers or the data browser.)

Your problem about inability to preserve partitioning has nothing to do with APT_CONFIG_FILE. That is entirely the province of the upstream stage's Preserve Partitioning setting. You'll need to give us a bit more information about how you are attempting to pass parameters to the Shared Container bef...