DSXchange

I got the rename to work for 1 file but can you generically rename all files in the folder (appending the timestamp) and moving to a new folder such as an Archive folder? OR do you have to create separate Execute_Command stages to do separately. I'm not UNIX savy so need a little help here. Thank yo...

I got the rename to work for 1 file but can you generically rename all files in the folder (adding the timestamp) and moving to a new folder such as an Archive folder?

Thank you,
Robin

Just an update. After I said that everything was ok in DataStage (and it was) another software broke (Quality Center). They had to reinstall the Quality Center software how they normally should do the install (and they didn't before) and now I can can get in Quality Center and DataStage still shows ...

THAT WORKED! Thank You Very Much! :D Note the change in the path for ..\InformationServer\.. The command we entered is below.
regsvr32 C:\IBM\InformationServer85\Clients\Classic\ExGrid.dll

Ok I'll pass this info on and see if the help desk will run. I will let you know if this works.

Thanks!

I can open it but there is no longer a columns tab or a properties tab. I have hard coded SQL associated with the ODBC stages but can't get at it. If I run the job it runs as if the SQL is there.

I haven't heard from my help desk so not sure what solution they are going to come up with.

Ok Thank You! I will let them know.

Thank you all. I posed the solutions to the help desk and we'll see what they decide.
Robin

I went to another employee's PC (not my own) and logged into DataStage Dev as myself and I was able to view the tabs.

Do you think it may be something to do with the Client that is messed up? Do you think reinstalling DataStage to my machine would fix the problem?

I can no longer see the Properties and Columns tabs on any of my ODBC Stages for DB2 or Sql Server. I can logon to another machine and view them. I had issues with some other software and they had to refresh some ACTIVEX information (I know nothing about ACTIVEX) and I don't know if that messed it u...

Just a note for file in case anyone including myself refers to this issue. I had to also add the Environment Parameter = '$APT_DECIAMAL_INTERM_ROUND_MODE' in order to use the Trunc_Zero within the stage. I think I tried it without and it didn't work.

Your suggestion worked perfectly. Thanks so much for your help!

Robin

I need my result of a division to ROUND DOWN not ROUND UP. In dividing 2 fields I need to truncate the decimal place to 7 positions to Round Down no Round Up. I have tried adding the Environment Variable $APT_DECIMAL_INTERM_SCALE for Integer Type and defaulting the scale to 7 and then doing the foll...