DSXchange

But if you've exported the job executable, you don't need to recompile. Yep, and you double the number of objects you have to store in your library. Deploying source code plus compiled code is a religious discussion, there's philosophical and practical components. I encourage my customers to adopt ...

How does being able to do so from a command line add anything? You can command line import, so if you're doing code migrations from a tool such as PVCS, you can easily integrate pulling the source code and importing into a scripted operation. You can't do the last step - compile. For these purposes...

But still, is that Reliable or not? I know English is not a native language for some members of this forum, so I'm not trying to be picky. Reliable can mean different things. A poorly written program can be reliable, it always does the right thing, but takes too long or is difficult to read. A well...

There's a bunch of ways, depending on you. Here's two: 1. In your job, add an extra output link to an aggregator and pass a column containing @OUTROWNUM variable. Do a MAX(in.column) type derivation, and have an output link from the aggregator to a text file. When your job is finished, you have an o...

Yes, do a command line FTP in binary and you get a 100% bit-perfect match of the file. Anything else is open to interpretation by the processes conducting the transfer.

Write a .bat file that invokes ftp. If you have a scripting language or interpreter like MKS toolkit, you can use that. Or, you can write a DS BASIC Batch job and use DS to do the FTP, all you'll do is run FTP using the DSExecute API. Simply open a DOS prompt box and type ftp, you'll see that it is ...

Folks, remember, the FTP stage is a READER, it reads the data file and sends data as rows across the network connection. Command line FTP doesn't CARE about the file, it transfer it in BLOCKS of data. You should NOT use the FTP stage as a file mover. This is like using a hammer to put screws into wo...

Setup a system DSN using MS supplied ODBC driver to Excel file. Search the forum for the issues you will encounter.

You can create a simple BATCH job that does what you need. Here's some pseudo-code: 1. Use the DSExecute API to run a DOS command line .bat file that executes a database command line shell (isql, dbaccess, sqlplus) running either a SQL script or stored procedure to create your insert row. 2. Use the...

Write your own jobcontrol with the required functionality.

ray.wurlod wrote:MetaStage is destined to BE the repository in a future release

(Pick your deity) help us.

Sainath.Srinivasan wrote:Use the routine below to get the date diff. If you have performance issues, you can change the compulations into the 'Case' statement to avoid unnecesary computations.

Beat you to it...

http://www.dsxchange.com/viewtopic.php?t=85788

ORAOCI is the Oracle 7 plugin, which does not work with Oracle 9.2 client software. Likewise, Oracle 9.2 client cannot connect to Oracle 7 instances. ORAOCI8 works with 8 and 9i client, 32 bit only. ORAOCI9 ONLY works with 9.2 client 32 bit only.

Is there any way to get this information without modifying every job? I've got a lot of jobs already created and it is already making me sick to think that I'd have to make big changes to each and every one. I was thinking about a job or stored procedure that could be called in each job. Possible? ...

Use the UV/ODBC stage, and search this forum as your technique has a lot of issues you will have to work out.