DSXchange

This is a mainframe job! -----Original Message----- From: Voon, Wendy [mailto:Wendy.Voon@team.telstra.com] Sent: Thursday, November 01, 2001 5:00 PM To: datastage-users@oliver.com Subject: RE: How to subtract 1 day from a parameter date in the transform stag e for OS/390 Firstly transform the date p...

Wendy, The functions you know and love are not available in DS/390 (mainframe jobs). This is why Paul specified that hes using the mainframe version. -----Original Message----- From: Voon, Wendy [mailto:Wendy.Voon@team.telstra.com] Sent: Thursday, 01 November 2001 15:00 To: datastage-users@oliver.co...

Hi, All I have a daily running job. It is a control job to call anther job. It has been in use for month. But last night, It happend a serious problem. The warning message is below: DataStage Job 831 Phantom 926 [1077] Done : DSD.RUN FactFRRevExp 0/2000 ServerName=xxxxx UserName=yyyyy UserPassword=L...

This is a topic for an orphaned message.

Firstly transform the date paramater into Datastage internal date and then subtract 1 from it: iconv(Date, "DYMD") -1 if you want the result back in the same date format as the date passed: oconv(iconv(Date, "DYMD") -1, "D-YMD") regards, Wendy Voon Consultant Black Diamond T e c h n o l o g i e s Le...

Hello, I have a date reading from a parameter file. Its format is CCYY-MM-DD. What I wish to achieve is to subtract 1 from the parameter date? Mind that I am using Datastage OS/390. I tried the following command but it did not return the expected result. The result returns me with the original date....

Thanks Ray. Would export of whole project to dsx, delete project, create project in target server, import project from dsx achieve the same thing? Most if not all of our hash and universe tables are create on demand. >Yes its possible. The format.conv command has -export, -import, >-delete and other...

Yes, but I wouldnt delete the original till Id tested the new version! -----Original Message----- From: kuan@clear.net.nz [mailto:kuan@clear.net.nz] Sent: Thursday, 01 November 2001 10:54 To: datastage-users@oliver.com Subject: RE: Setting Up Projects Across Servers Thanks Ray. Would export of whole...

Hi All I wonder if this is possible. Currently, we have datastage and three projects (dev, test, prod) all residing on one server. We are thinking of moving or recreating dev and test on another server. The idea is to have production running on one server and development and QA on another and to rec...

Im experiencing a strange issue with the client apps: Designer/Admin/Director/Manager with DataStage 5.1. When using the admin user: dsadm the response time is great. If I use any other developer, the reponse time is 5 times slower. When I run a job from the Unix command line it works fine with eith...

Yes its possible. The format.conv command has -export, -import, -delete and other options to allow you to accomplish the moving of SQL schemas (each project is a schema). You can NOT do it successfully simply by using operating system commands. Seek assistance. As to the performance impact, how long...

Hello again. Im having a little performance problem in one of my lookups, the sql query is quite fast and im using indexes to speed up the sql query, can any of you suggest other means to speed up the lookup? Id be really grateful, and its a good theme to discuss in this forum. Thanks for your patie...

Using DataStage 5.1 you can take full advantage of some of the new features: 1) Take the job design create a shared container from it and them move the container into each job and localize it before customizing it. Depending on the differences in your job designs you could even containerize the firs...

I did the same thing...... >>> dirkm@reach.co.za 10/31/01 09:45AM >>> So simple actually, I was just clicking in the wrong place. Thanks Lindi, I appreciate the help. Dirk -----Original Message----- From: Lindi Reichel [mailto:lreichel@psu.edu] Sent: Wednesday, October 31, 2001 4:37 PM To: datastage...

So simple actually, I was just clicking in the wrong place. Thanks Lindi, I appreciate the help. Dirk -----Original Message----- From: Lindi Reichel [mailto:lreichel@psu.edu] Sent: Wednesday, October 31, 2001 4:37 PM To: datastage-users@oliver.com Subject: RE: Deleting column definitions When you hi...