DSXchange

thank you Ray. I found the reference in the Server Job Developers Guide. -----Original Message----- From: Ray Wurlod [mailto:rayw@mindless.com] Sent: Tuesday, October 15, 2002 4:05 PM To: datastage-users@oliver.com Subject: Re: Starting a DataStage job from a DOS batch command file The executable is...

The executable is dsjob (dsjob.exe on Windows platforms). It is described in the Server Job Developers Guide, and has been discussed a number of times on this list. Type in dsjob alone at the command line to get a top level syntax. Type in an incomplete command (for example "dsjob -run") to get furt...

Hello All, I need to check input date fields to ensure that they match the corporate standard: YYYYMMDD. Is their a DS transform or routine that checks to see if a date is in a valid date format? Ive looked at: DateGenericIsDate - Only tells you if a dates valid. Example 2/29/2002 is not a valid dat...

Hi! Do you know if it is possible to execute a DataStage job from a DOS batch file, or a DOS command prompt? I remember havind read something about this, but I cant find it. We have a VB application that needs to kick off some DataStage job. Thanks again Christian Christian Pelletier Sr. Engineer Pr...

Thanks Ricardo I just ran another test without the "flash after every row..." ) It is a little faster (168 rows/sec vs 44 rows/sec), but still far from using a straight sequential file (13000 rows/sec). Each rows contains 750 characters. I will make a test with smaller row. I also expected the Named...

Hi Chrstian, I dont know why your process is so slow, I expect it should be faster. I tested the Named Pipe option in the past but only with few records. I think you can verify (on the Sequential file stage properties) if the "flash after every row" option is selected and if read/write timeout value...

Hi James, you have to use Stage variable to save your input fields ("phone_no", "cic", "ji") and to create two flags where you can test if "ji" field (i.e. jiFlag) and "status" field (i.e. statusFlag) change. In this way, you can test (using "jiFlag" and "statusFlag" into the output constraint) if "...

Hi all! I have been running some tests yesterday using the Named Pipe option (sequential file stage). While I was expecting the process to be faster, it turns out that using Named Pipe was 60 times slower than sequential file...!!!! Could I tune some settings to speed up the process? If so, what are...

Hi everyone, I have a job to create which will dynamic insert a record during transformation stage. Whenever status changes to N, it will create a record with earlier date_created date with status P as mindate and using date_created with status N as maxdate(see example below). Here is tricky one, if...

One tip; if you do use ODBC to connect to Excel, when importing the Table Definition, make sure that "show system tables" is checked. Each Worksheet in an Excel Workbook is a "system table" (the names import with "$" suffix to indicate this fact). Also, it is vital that the first row in a worksheet ...

Thanks for your suggestions, Tim and Himanshu. We are going that direction--macros and VBA--and pre-process the files as you describe. WE have some ODBC stages set up for direct input with the multiple worksheets within EXCEL viewed as "tables" which unfortunately have too many extraneous rows and c...

The VB app I used was on Windows NT to SQL Server, FTP sites etc... The App accepted a parameter ( the Excel sheet name ) and then extracted the data in columns specified in an ".Ini" file stored on the DS server. Users maintained their Excel sheets on their own machines or shared folder. A nightly ...

Can you give us a little more information about your environment: Is DS on Windows? If so, can you create ODBC connections to excel (comes with Windows 2000, etc.) and call the ODBC DSNs within DataStage? You can also tighten down the security on your MS Excel files so that people can only enter dat...

Ive worked on code using Visual Basic to extract data from an Excel Spreadsheet and write the data out as a text file that datastage can then use. Also, you can use Macros in excel to write the data out to a database first. But I think to have it entirely automatted, a VB style approach is best. The...

Has anyone worked with Microsoft Excel spreadsheet(s) as a source in DataStage? Were looking for better ways to automate the "cleanup" of spreadsheet data within DataStage, if possible. So far, our "cleanup" is much too manual since these files are multi-worksheets with their obvious imbedded formul...