DSXchange

Any suggestions as to how I can perform the conversion within a transformer? From the transformer you can call an parallel routine that you can write in C that does a simple efficient translation from EBCDIC to ASCII. A simple while loop and a couple arrays would do. The advantage of doing this is ...

Hello abc123, MQ Series is an IBM product that allows for real time queueing of messages produced by a source and consumed by a consumer. To learn about it you should search the IBM site. The MQ Stage is a plugin that allows for reading and writing messages to a MQ Series Queue. There is a plugin do...

I receive the same error when attempting to write my result of combine records to a sequential file. It does however properly work when writing to dataset or peek stages. Perhaps it is not possible to write a variable length vector out in sequential file stage, or at least in the documentation for c...

Hello Forum,

Is there a general string cleansing function in parallel job like OCONV-MCP to remove all non-printable characters? The only way I can figure to do this is to explicitly list all the characters you wish to translate in a convert function call.

Any other suggestions?

Thanks,

Greg

Hello Forum, I have a couple questions regarding lookups. 1. If I have an SMP configuration with n logical nodes specified in the APT_CONFIG_FILE, and I am using 'entire' partitioning strategy for my lookup filesets, does DataStage load n copies of my lookup into my hosts memory, or is it smart enou...

Hello Forum, It seems to me that the CFF is somewhat less useful in Parallel Jobs than in Server Jobs. The majority of files I receive from MVS have multiple record types and redefined fields. In server edition I would handle each record type on a separate output link of the CFF. It would appear to ...

I have received this error when using the omit option to log into Administrator client. My domain id belongs to the Administrator group on the DataStage server.

When I explicity log on to the server with my id and password I do not get this error.


Greg

Hello Forum, In searching I found a few post references to 'Sybase Enterprise Stage'. I'm on 7.5X2, and don't see this in my repository. Is this a Unix only feature, or separately purchased package? Is Sybase OC plugin the best option for reading Sybase data on 7.5X2(Compared to ODBC Enterprise stag...

Thanks Ray, That sounds like great news to me. However, on my client after loading or saving table definition onto column grid, and clicking on grid properties, there is no extra field that corresponds to the table definition. Perhaps it is a 7.5X2 feature, but the only columns listed on properties ...

Hello Forum, If my dataset has all the transformation already necessary to meeting my loading requirements, is there any advantage of placing a dummy transformer between the Dataset and TDML stages. For example, DS-->T-->TDML Versus DS-->TDML Any performance and/or reject handling differences? Thank...

Ray's answer applies most of the time. I prefer to use external tools to DataStage to do this check, rather than the overhead of setting up a test in DataStage. First, I need to know something about the content of the data before you can determine if it is in EBCDIC of ASCII. ei. If you know the fir...

Hello Forum, Where does MetaStage obtain the column information necessary for it's Data lineage and cross impact reports? Does it obtain them from DataStage repository table definition objects, or from the column information on the individual jobs themselves? I consider this an important difference,...

Hello Forum, I'm confused as to what functionality the "Program Sources" checkbox servers on the export from manager. Is a program source the same as the job design? Is this option simply for when you want to use executables as the driver for exporting and not a job/sequence design? Thanks...

Hello Forum,

Is there a way a quick query to produce a report containing the size of all the RT_CONFIG tables/files?

I understand that auto purge options only take affect during import, unless manually set on job or with script.

Thanks in advance.

- Greg

This post deals with unix platform, which is pretty well covered by the samples directory on the cd. What is not contained there are Windows compilation examples.

Does anybody have any recommended compilation flags for parallel routines when compiling with Visual Studio .net?

- Greg