DSXchange

Where's a mainframe when you need one?

I hope I'm not adding to the confusion. If I had access to DS390 and the mainframe, I would confirm whether or not that this date arithmetic can be done in the Transformer stage. I'm paraphrasing from the DS390 documentation....... If the default date format specified in project or job properties is...

What's wrong with using stage variables?

In your case, it seems appropriate.

The short answer is , yes; you'll need to upload the generated source code and JCL to the MF.

If you're going to continue to develop with DS390, you'll need some training.

I'm curious.

Did you try what I suggested? I.e.:

What is the result when you derive DAYS_DIFF as:

CAST('2005-01-01' AS DATE) - CAST('2004-12-01' AS DATE)

I don't have access to mainframe and DS390.

What is the result when you derive DAYS_DIFF as:

CAST('2005-01-01' AS DATE) - CAST('2004-12-01' AS DATE)

In case you want to do the date arithmetic in DS390, you should become familiar with the CAST functions.

E.g., cast the dates as integers. The difference will be the number of days.

There are lots of scenarios. Is this one an option :

1. Use a MF utility to 'unload' the data to a sequential file.

2. Transfer the sequential file from MF to Unix.

3. Transform and load on server.

I have a source field defined as PIC X(4). I expect to receive values like (where b = SPACE): '0.25' '1.00' '+1.0' '-0.5' 'bb.8' 'b.5b' My target column is defined as DECIMAL(3,2). DS390 performs the CHAR to DECIMAL move correctly, as long as the the field is a combination of leading/trailing spaces...

I have a job design for which the generated code will not bind/compile. :( The SQLCODE is -134. The problem DBRM statement is the SQL generated for a lookup based on the equality of a host variable and a (reference table) column that are both defined as VARCHAR(350). Apparently, DB2 restricts host v...

I guess I spoke too soon. Although the 'IS DATE' function is available in v7.5, it is both undocumented and unreliable (see case G65511).

Never mind.

On the same topic.... Srikie, use of the 'IS DATE' construct in your transformer or business rule stage might satisfy your date validation requirements, instead of calling an external routine. I have a related problem that you all may be able to help with. We're running v7.5 and experiencing random ...

Installing and configuring the QualityStage Plugin should probably be straight-forward, but I've been working at it for a couple of days now. E.g., I had a bit of trouble just starting the QSRT Manager. Don't assume that port 6010 has been registered/reserved. The QualityStageMetadata Plugin works a...

NEO, Craig's recommendation to use sort -u should apply in your case, as well. Your sort involves two(2) key fields instead of one(1).

-Dave

Prem, I experienced the same problem.

I attributed it to 'automatic' LOADMODE with an Oracle9i target.

I'm running DS v6.0r3 on Solaris 2.8.

When I changed LOADMODE to 'manual', the job ran to completion.