Running Standarize Jobs from ODBC

[loreandre]

Hi!

I need the aid of you for to solve my problem!!.

I need running my job from ODBC not from a flat file. When a file is run in QualityStage it is necessary to have an input file in the folders data. In my exercises I need that this file be from to Data Base.

I wait for its answers!!!

THANKS!!

LORE

[jhmckeever]

LORE,

You rightly said that QualityStage requires data in Flat File format. If you are using DataStage to host your QualityStage job (using the QS-for-DS plugin) you can stream data directly from an ODBC stage into your QualityStage job.

If you are not using DataStage (and wish/need to use QualityStage stand-alone) you will need some other mechanism for converting your ODBC data into a flat sequential file (E.g. Excel!?)

Hope this helps,
J.

[ray.wurlod]

You can use a Format Convert stage within QualityStage to read directly from ODBC sources.