DSXchange

DSGetStageInfo() does not take a list of stage names as its second argument. It needs a single stage name. So YOU need another loop. You probably also need a loop for the links within a stage. Message = "Link Row Counts" StageList = Convert(",", @FM, DSGetJobInfo(hJob, DS...

You should, of course, have recorded them on the job's Dependencies tab.

Hindsight is a wonderfully exact science!

Version 1.0 was released in November 1997 by VMARK Software (I was there). VMARK and UniData merged to become Ardent Software, which was acquired by Informix Software in 1999. Informix sold all its database products to IBM in 2000 and reinvented itself as Ascential Software which, as you are aware, ...

If you must, select them as VarChar, possibly using a CAST function in the column derivation in the DB2 stage. But why do you think you need double quotes? It's a numeric value - the "rules" for CSV files specify quotes for character string data.

What did you do differently?

DataStage job logs are not stored in UniVerse tables. They are stored in DataStage tables. In any case, the job logs will not give you the stage names in a job. Before we will even look at your code, please encase it in Code tags so that the indenting is preserved. You can edit the previous post; yo...

You designed it. Only you know every component that you used. You don't need to export stage types, because their DataStage project will have these too (or will need to install them). But you do need to export every component that you or one of your team created which forms part of the job design in...

The only safe answer is "it depends". It depends on your career hopes and aspirations. It may provide valuable contacts and information sources if you are considering a career or business in Data Warehousing. But there are associated costs. And are you considering such a career or business? Visit th...

120267 wrote:Ray,

The count of the products are not Defined, It is dynamic.If we get 60 products we have to split as 60 files with product name as the file name.We may get more than 100 products also.Is there any solution with out implementing using loop.

I answered the question that was asked.

If the data are provided in flat files, there are two possibilities. The first, and most likely, is that everything is text. In this case you can declare data types using standard SQL forms; VarChar, Integer and so on. The other is that they are generating a file that contains binary numeric data (a...

You shared library paths are inconsistently named (LIB_PATH vs LIBPATH) and do not seem to have the usual range of entries. When adding entries, you need to preserve the prior entries. For example

But are you setting the First Line is Column Names property (on the Stage tab Properties) to True? I suspect not, as noted earlier.

You don't call it from any stage - that was my point. Unless, of course, you call it from an after-stage subroutine, which only gets executed once.

Is the offshore team developing or testing? If the former they will need the job design; if the latter they will need the job executable (and probably the job design). In addition they will need all repository objects upon which the job depends; data elements, routines, shared containers, table defi...

It wasn't SLEPP, it was SLEEP.

I tested it in a BASIC program yesterday on a Linux system running 7.5.1A and it worked fine.