DSXchange

Hi,

is it possible to pass arguments in Datastage at Runtime?


regards,
sunshine

i am creating a job with source database and target database. source ----> transformer--->target lets say source has 10 records.because of using some programming stuff/conditions in transformer stage, only 5 records are inserted into Target Database. i need to trace the number of records in source a...

[quote="chulett"]Pivot stage.[/quote]


u mean

source ------> pivotstage---->target


??

hi my source is a database with data like: table:orcl_source marks quarter1 quarter2 quarter3 quarter4 maths 23 12 32 34 physics 44 55 54 32 i am planning to display data to a flat file in the format like: target.txt: maths;23 maths;12 maths;32 maths;34 physics;44 physics;55 physics;54 physics;32 ca...

[quote="sunshine"]in designer, when i double click the universe, in General page, in DSN dropdown list is empty.

can somebody has idea,why DSN dropdownlist is empty?

Advance thanks,

sunshine[/quote]



i got the answer.
i forgot to import the table definitions in the repository.

sunshine

in designer, when i double click the universe, in General page, in DSN dropdown list is empty.

can somebody has idea,why DSN dropdownlist is empty?

Advance thanks,

sunshine

[quote="ArndW"]Sunshine, did you try the DataStage telnet after you did this to see if it works? If it still doesn't work, please talk to your system admin who might know a bit more about the installation and the last step is to talk with a support professional at IBM/Ascential or whoever ...

Hi, you are right. but in my control panel, i can see only "telnet server administration". no where i can see MKS toolkit. sorry,i am really a begineer to datastage and these MKS toolkit stuff.. :) when i click telnet Server administration, i can see the following: ########################...

Hi,

One basic question:

why we need the following services running for datastage?

Datastage Engine Resource Running
Datastage Telnet Service
DSRPC Service.

where can i find more info on the above services.

Advance thanks for your reply.


Kind regards
sunshine

[quote="ray.wurlod"]It's probably the MKS Toolkit telnet that's occupying port number 23. This starts before the DataStage Telnet Service. Change the DataStage Telnet Service to Manual, and just don't start it. You can get there via the MKS Toolkit telnet if you need to. Alternately, cripp...

[quote="ArndW"]You can link to pictures using the "[quote][url={urlpath}]Name[/url][/quote]" syntax if you can put your screenshot .jpg or .gif file somewhere accessible to the rest of the world. You might be getting the Windows TELNET server error message because the service isn...

[quote="ArndW"]You can only have one service running at a time, so you'll have to stop the Windows service before the DataStage one will work. If you really need both services at the same time you will have to read the documentation on changing the ports, I've never tried that before.[/quo...

[quote="ArndW"]Sunshine, I think that if you have a "controlpanel/Administrative tools/Telnet Server Administrator" visible then you installed the Windows TELNET server; which is why your DataStage telnet service isn't functioning.[/quote] Ok, when i double click Telnetserver adm...

[quote="ArndW"]Please try to stop and start the services using the DataStage applet in the control panel itself. This applet is called Ascential or DataStage (I can't remember) and has the Ascential logo; this application will start and stop all the services together and in the correct ord...

[quote="ArndW"]Sunshine, what OS are you running on your PC? Do you have any other packages installed which might conflict with DataStage Telnet's port - such as a third-party TELNET server (not a client, that is not an issue)? If your PC is at the low end of the performance scale then you...