DSXchange

Hi dvn_ascential and welcome aboard :!: , Sounds like you're trying to define the metadata in your input Data Set stages in the funnel job that writes to the target table. If I've understood your question correctly, here's what you need to do. You need to save the meta data of each of the three Data...

Ahhh, there it is.

Wonder why it's not in the Parallel Job Developer's Guide?

Thanks, Guru.

Am I blind, or is there no documentation on the Pivot Stage in EE?

Rob

praburaj, You need an output column in your transform stage that has a derivation something along these lines: If input.expense_level [1,3] <> 'LPG' then input.expense_level else if input.expense_level [1,3] = 'LPG' then 'NPG' : input.parent_expense_level [4,30] else if input.expense_level [1,3] = '...

kris007 wrote:Rob,
Can Datastage server be a Mainframe?

We aren't running it that way.

I'm not too familiar with the MVS version, but I don't believe that the engine runs on the mainframe, it just translates the code to COBOL which in turn runs up on the mainframe.

Rob

Chris,

We run our DataStage jobs from the Mainframe at my current client. A host utility called 'Universal Command' that has a component on the host and on our DS server is used. A call is made to the utility and a SYSIN specifies executables, parameters and some error handling.

Rob

Hi Meena, Typically, DataStage doesn't care about the data contents until you try to insert into a Database table or some other place where data is strongly 'typed'. Usually I get this error when I've been carrying data that is defined with greater length than the target database. Check the metadata...

Yes, there are more inconsistencies, e.g.

In the first message, the code is
later it is
We need to see the exact code that is generating the error.

Rob

In this case there must be some other column in the records that determines which one will be active. The business rules for the values in this column need to be applied, allowing only one to be inserted as 'active'. How are you indicating 'active'? Do you have a flag or are you using a date? In thi...

kris007 wrote:... and also I need the column name which has the maximum date...

Need to think about this one some more, the case statement will not provide the column name.

Kris, what are you going to do with the column name after you determine the max date?

Rob

Perhaps I'm misunderstanding, but is the file layout AND the data in the same file :?: If so, then the CFF stage is probably looking at the first line(s) of the file, which may be blank, or contain info from the file layout. Data and meta data have to be in different files. Please expand your descri...

Both types of transform stage are slower, with the BASIC being, in most cases, the slower of the two (overhead of BASIC vs overhead of C++).

After a long interlude, I have found the documentation that I'm looking for. The set of Orchestrate manuals I had access to at the time did not go into any particular detail on this topic. Since then I have found - RecordSchema.pdf - to a lesser extent, OpsRef.pdf The first document goes into specif...

You can look in the tabular output grid of the transformer and you'll see that a 'Server' transformer has a couple of extra fields called Display and Data Element. OK, I created a parallel job where I use both a BASIC transformer and a normal transformer. When I open the properties, indeed, the BAS...

Folks, While reviewing an existing job in EE, I'm trying to determine if the transforms on the canvas are BASIC or not. There is nothing in the properties that indicates the type. They don't appear to be using any BASIC routines, yet there is no 'fan' symbol on either the input or output link. Is th...