DSXchange

Izack wrote:What is the use of Stored Procedure Stage ?

To invoke a stored procedure (d'oh!) for every row processed.

You can also invoke stored procedures from the Enterprise ODBC stage, but with more restrictions.

True. But someone had already posted that you can specify VarChar. Then all will be well. After all, there are no "real" data types in text files, only text.

Ah, yes, that's be it. You can get a list of PLZs from Deutsche BundesPost.

And I doubt that these are the ones where "single file" is being enforced.

If they are, the solution is simple. No more parallelism.

When "they" complain, the response is that it's the cost of stupidity.

Surely this is the simplest of C functions to write?

Initialize a integer to 0, step through your string from postion 0 to len-1 taking the character value and incrementing your integer.

DSguru2B wrote:A simple solution. Use a bulk loader. It drops indexes and rebuilds them after the load finishes as part of its procedure.

Not true for all databases.

There is no cure for stupidity. What you can do is write them all to the same table (or even hashed file), using a generated key. Once all the runs are done, you can dump its contents to a single text file. Or you can dump them to separate temporary text files (job parameter for its name perhaps) an...

pnetti wrote:The original code hardly makes sense.

Is that because of your unfamiliarity with the language, or do you really have a problem with the logic?

The Iconv() and Oconv() functions are perilous ground for newbies, particularly the ones that handle binary data.

Anyone using a source code control system relies upon the fact that the DSX is checked out as the "lock" you seek. Once it's checked in again, someone else is entitled to check it out. While ever you have it checked out, it's "locked". It's easy to enforce; any violation is a sackable offence. Someo...

You must find out how the data are encoded within Oracle. You may find that the Oracle terminology is different - it may include the magic number 1252, but is unllikely to include "MS" since that would be free advertising for Bill's mob. It probably contains the word "American".

Look in the "environment variables" event in the log - usually the second event posted in a job run. Are your environment variables set? Add a diagnostic call to your routine after your call to DSExecute. $DEFINE TESTING $IFDEF TESTING TestMsg = "After call to DSExecute value of UnixOutput = &q...

HashedFile HashedFile | ^ | | V | new data ----> Transformer Stage ----> DimTable (inserts) ----> FlatFile (inserts) ----> DimTable (updates) ----> FlatFile (updates) The Hashed File is pre-loaded with an image of the dimension table, but keyed on the natural key rat...

Read the Manager Guide (page 8-17). The only external functions that can be imported are ActiveX (OLE) functions. Therefore the DLL must have been constructed as an OLE server. Exactlly how this is achieved depends on the language and the environment, and I don't profess to be an expert - the last t...

I presume there's more than that - at least a closing tag for report_info?

Have you attempted to create a job that uses the XML Input stage to extract data from the XML? If so, can you describe this job - what stages are in it and how you configured the XML Input stage?

These plug-in stages are purchased separately from your vendor (the extra cost is due primarily to SAP licensing/certification charges). With them you get the usual PDF format documentation. Search the IBM web site for information about SAP connectivity, which is available both for SAP R/3 and SAP BW.