DSXchange

In what sense? As a client - sure. As a Server - don't know. Someone else here will or it will be mentioned in the docs or on the Ascential product availability website.

Lots of help already here for working with sequential files. Try reading your documentation or searching here for keywords like OPENSEQ, READSEQ, etc. Then ensure the routine returns whatever is appropriate from the sequential file to be used as a parameter value. Move the User Variable Activity sta...

surendra_ds wrote:I dont think the size of folder will matter in any ways as far as DataStage is concerned.

As I noted, is does matter.

Just been through a similar exercise. It's all in the NLS_LANG settings you are using, both in the database and on the 'client' side. And it's not that the problem is caused by the OCI stage, but by Oracle itself. You set them globally in the dsenv file. You can override them in any job by including...

Umm... there's no need to send you anything.

Connect to your project with the Manager. Navigate to the Routines / sdk / Key Management category. The routines will be there.

Sort the data and then assert that in the Aggregator stage.

Yes, there are known but undocumented limits on the sizes of files that can be sucked thru a Folder stage. It seems to vary from version to version and O/S to O/S. When you find those limits, as far as I know the only thing you can do about that is ensure that your files are all under that limit - e...

Open up the Transformer stage. In the topmost menu bar, the icon on the far right (with the blue arrow pointing up and down) allows you to specify the Output Link Ordering. And changing the link order will not affect the layout on the canvas.

Ok... I know it is possible. My point is that (IMHO) it is the wrong approach - the Folder stage should be used with XML files. Most people would either concatenate the four files together before-job and process them at once, or create an interative process where you loop four time and process each ...

I've never tried to use the Folder stage with sequential files other than to get a list of file names, not contents.

The Folder stage is meant to process XML files and so is typically followed by an XML Input stage which does the parsing into rows and columns.

Hypens? As in dashes? I don't recall DataStage supporting column names with hyphens in them.

In any case, if they occur in the same order you can select them all from one side and 'drop' them on the other.

Off the top of my head, both the Sequential and Hashed stages.

What happens when we Reset/stop the jobs which are aborted or hung? Nothing happens to the files or tables inside the job, the status of that job is reset so that it can be rerun. See page 3-5 of the Director guide. This is true unless that 'Automatically backup' option is enabled in an output stag...

If we upgrade the Datastage from 5.1 to 6.0, What would be the impact on the existing jobs. There really shouldn't be any. Mainly, how the Hashed files will be impacted. They won't be. Hashed files are hashed files. Are all the stages in 5.1 are supported by 6.0? Yes, of course. Are IPC stages &...

dspxlearn wrote:My problem is, can a routine return more than one value.

To answer your question - No. You need to do exactly what it sounds like you are doing, returning some kind of delimited value and then breaking it up into its component parts after the fact.