DSXchange

I am using a flat file the other side. I need a flat file because the Link Collector does not support active stages. Still you dont need an intermediate flat file. Just go to Job Properties --->Performance --->click on "Enable Row Buffer" ---> "Inter Process" or you can also use...

Alternate way, using @INROWNUM
instead of 1 or any other line number, you can use a job parameter. It would give you more flexibility

can i know whatz on the other side of the transformer ? I mean which passive stage you are using after the transformer. If its any of the databases you have in datastage, then check the director if your 20 "missing" rows are not rejected. Second thing, I would like to know(jus for my under...

Well you could have easily found relevant thread, if you would have used keyword "rebuild" while searching. Anyways, to check if the jobs in your project needs index rebuilding. Use: LIST.INDEX DS_JOBS ALL, on Command tab in DataStage Administrator, to re-build the indexes. If it requires ...

basically all user defined routines are prefixed with DSU and all in-built routine are prefixed with DSX.

And DSGetLinkMetaData is a function NOT routine or Transform, so you need to declare it by adding below line, on the top.
$include DSINCLUDE JOBCONTROL.H

there are several discussion on this, search the forum.
use keyword like; restart, restartability...

some links:
1. viewtopic.php?t=93077&highlight=restart
2. viewtopic.php?t=91046&highlight=restart

Find the solution in the below post:
viewtopic.php?t=92940&highlight=

Hi Basically, I have used env variable in my job it works but when I am trying to assign it to a local variable or port and store it in target as a field, it's not working ? any clues ??? reading the above part, of your thread, I feel that with local variable you mean Job Parameter and if i am corr...

Assuming that there would be another KEY column along with the column you have mentioned in your example, I would suggest you to refer the below link/post:

viewtopic.php?p=123634&highlight=#123634

amsh76 wrote:Wait a sec...do you mean three rows ???? and not columns

If thats the case then look at Pivot Stage....

Sorry, if I misinterpreted your question.

Pivot stage cannot be used for rows to columns conversion, pivot will help you transform the other way i.e., columns to rows.

You still don't need a driver. You need to specify the hostname (and maybe some additional information) in uvodbc.config where you define the UniVerse data source. I have already tried that. In the uvodbc.config file I have added. <TESTUV> DBMSTYPE = UNIVERSE network = TCP/IP service = uvserver hos...

I can give localuv, if my hash file lies on my local server. But what if it lies on some other server.

Hi guys,

I would like to know, which "driver" should i select/use for creating System DSN for a Universe & Unidata Stage.

By changing the line termination you could have got the records in different line. I dont how or watz the reason? :? But did you check if the data is correct for each of the columns? i feel for Packed Decimal columns you must have got some incorrect values or junk values and it would have also affec...