DSXchange

If you want to have your personilised output , then you have to specify the extract . define your file structure. and you can map them using extract feature . all the system variables and source and reference file fields are available for you to see and add for out put file or extract file. when you...

I am not even working on VPN . Directly on company network.
but even I try to work on Remote desktop on server, still I am getting the same problem.

Change ur NLS value to ISO8859-1 . This will work the example you mention.

hi, my design is jobactivity------>routine activity. iam calling keymanagement next value function in the routine activity. In routine activity tab. name value expression ARG1 'job1'. when i go to director, i can view the message, Routine activity started and finished, status=1, executed ok. if i w...

I_Server_Whale wrote:How about the "command" dialog? Does it take that long too? Or is it just the "properties" dialog?

it is only properties dialog taking time. Command dialog is OK , coming quick.

Hi Gurus, I am using Windows version of Data Stage 7.5 . It is taking very long time to open properties dialog in Administrater. it is taking 25 - 30 min to open the properties page. I have only 5 projects. Any suggestions to make it fast. like some configurations changes or cleaning up some files. ...

You can ru thru DB2 Stage using the Custom SQL or using load sql at run time option ..... Hi I have the following environment as mentioned above with DB2 as the database. I need to run custom .sql files from within the datastage environment without invoking any shell or script. Is there a way to do ...

Whatever you did to export the .PST file, wrap that in a BAT file and execute it from DataStage control (for example an Execute Command activity in a job sequence, or a before-job subroutine). ... Ray, I did the export from Outllok GUI , but I am not sure how to do from Command Prompt. I am looking...

You cannot use DataStage to read .pst files. The format is not only quite complex but oftentimes these files are encrypted as well. I did a quick google search and there are products out there that will convert .pst files to text ones; or you could even try an Outlook export. Once you have a text f...

Hi , I got a requirement to process the contacts information from Outlook using DataStage. I want to know how we can read the .pst files in dataStage. We are using Server eddition , windows version. I donot want to change the .pst file to csv or excel initially. I know this work aound and thats my l...

try using 'DSJobStartDate' DSMacro in your transformer , not in SQL and use 2 seperate paths for Update and Insert logic.

HI Stiwari, DId u check the output link properties of hash file and gave the same name as it is loading in input link and make sure u have same column line up in both the links , inout and out put.... Suresh Hello everyone, I need help in hashed file. I am taking input in hashed file from SQL server...