DSXchange

-----Original Message----- From: Cook, Robert E. Sent: Wednesday, November 14, 2001 5:25 PM To: Tirnadi, Al; Anthony, Barbara C.; Pardy, Brian J.; Shpak Jr, Daniel; Broughton, Cindi E.; Kammerer, David W.; Golia, Donald J.; Suri, Deepak; Porydzy, Ed J.; Zygmunt, John W.; Rosenthal, Jonas S.; Moran, ...

Hi All We have a customer that Run datastage 4.1.1 on NT 4.0 and IQ 12.4.3 on the same box. When we connect to IQ via ODBC all processing is slow. If we use DBISQL with the same ODBC the processing is lightning fast, if we use winISQL with the ODBC the processing is slower than DBISQL but still fate...

Greetings fellow DataStage Users My Question is, have anyone successfully used the DB2 plugin and Bulkloader. I am trying to get this to work on a Sun machine but with no luck. Ifve change the dsenv file according to the documentation but with no avail. The only way around it, is using ODBC but by u...

Wendy, We recently went from DS 4.21 on Solaris 2.6 to DS 5.1 on Solaris 8 and all has gone fairly well. We do not use the ODBC stages, only the Sybase plug-in. Only issue was a hanging job when the datatype on the Transform and Sybase stage were not the same. Peter -----Original Message----- From: ...

Hi,

We are currently running Datastage 4.0 on Solaris 7, and we will be upgrading to Solaris 8.

Has anyone been through this or are aware of any issues?

Regards,
Wendy

To test our ability to do restores from backup of a project, we did a backup of our production project and restored of the Unix file system on to our test server. On checking our restore we found Universe was available as was Datastage but we were unable to get odbc connections In the end we bounced...

The simple solution is to reply in the mode the question was asked. Brad was using TCL and asked for a solution to the TCL problem. I was trying to help him, not make him work harder. (In the context of the "RESET JOBS" question the overhead of the command parser is not a major factor). The purpose ...

There IS a simple solution - dont use TCL! See the code fragment I posted earlier, for example. This also avoids the overhead of invoking the command parser and all that that entails. Curious why an earlier poster used SSELECT rather than SELECT; if youre going to process all records (job names) the...

Brad, There is a simple solution to the wrap problem. Modify your TCL command to read - "LIST DS_JOBS NAME FMT 80L ID.SUP" the FMT key word tell it how to handle the width and justification. in the example it will give the data in a column 80 characters wide, left justified. It you want to right jus...

Hi Craig, Here is the control loop that will read all the jobs from the DS_JOBS file and let you process each one to checK the status and reset if necessary. Just place the enclosed code in the JOB CONTROL section of the Job properties section. The place for your code is marked. I hope this helps yo...

Open "DS_JOBS" To DSJOBS.fvar Then * Process all keys from DS_JOBS file Select DSJOBS.fvar Loop While ReadNext JobName * Dont process control records from DS_JOBS If JobName Matches "1A0X" Then GoSub ProcessJob Repeat End Else Message = Unable to open "DS_JOBS" file. Call DSLogFatal(Message, "Contro...

One of the techniques taught on the "Programming with DataStage BASIC" class is not executing a job from a job control routing unless the job is in a runnable state, which may involve resetting it first if it is in a resettable state.

Craig asked, "As an alternative, can someone give me the syntax to read thru DS_JOBS > retrieving the Job Name?" > Sure. At TCL in Telnet you can say, "LIST DS_JOBS NAME ID.SUP" and it will list just the jobnames. The only problem is any jobnames longer than what the data dictionary has for the leng...

Thanks, guys, for the very helpful information. I was aware of the routines, but not that I could use them to reset jobs. I also saw that there is a "DSGetProjectInfo" routine where I can request a list of all jobs in the project, which looks like a good way to get all of the jobnames to loop thru u...

Pedro - I have noticed from working with the "append" feature that it is unreliable, especially if it is used in the middle of a long, complicated job. It is common to run the same program a number of times in succession with the same input files and get totally different results in output. if youre...