DSXchange

I was looking for the editor commands.

ED VOC
>?

Thinking someone had some notes.

Couple things:

What are the commands to add itmes to the VOC file?

For instance, DS.TOOLS and UNLOCK

Also, anyone know where DS.TOOLS is documented?

The range of time intervals in the lookup range from 5 to 270. No ulimit in place so the time interval is not capped in any way. I think i may have to explore flattening out the row into muliple rows per time interval.

Quick Question: Is it possible to achieve a between condition coming from a lookup (hash file lookup, oracle source/stream link)? i.e. lookup: key_fields, beging_date, end_date stream link: key_fields, actual_date I want to find the key_fields that the source.actual_date falls between the begin and ...

I had a sales engineer give us a demo a few weeks ago. I think most of the improvements revolve around the cosmetics of the designer and the added parallel features. There are some nice features in the job sequencer. Of course they added in the parallelism functionality to the director (not sure if ...

I should have researched this before. It appears the jobapi.dll is not shipped with 5.2! Hmm? I'm upgrading from 4.2 to 5.2 and now realize my parameter programs aren't going to work. Does anyone know why they removed the dll? I've opened a ticket to see where the functionality can be achieved. I se...

See the reply for the other oracle stored procedure topic. You could have a wrapper function (pl/sql call spec) to call your java stored procedure. It works. Hi everyone, Am trying to understand the means and methods of invoking Java Stored Procedures from Oracle Database - 8i/9i. Has any one done t...

Here is a quick and dirty solution. 2 objects, table and function. You can place the Sql statement (insert) into the before/after table on the SQL tab in your OCI stage. Keep in mind that the stored procedure you call cannot have COMMIT and ROLLBACK statements. *** This is not used to process a resu...

This paragraph should help you get started MY_PARAGRAPH 0001 PA 0002 CONNECT ODBC_DSN 0003 DATA USER_NAME 0004 DATA PASSWORD 0005 DATA {CALL STORED_PROC_CALL('ARG_1', 'ARG_2')}; OR 0005 DATA MY_SQL_STATEMENT; 0006 DATA .Q I need to do database access using BASIC routines. Can any one help Thanks.. N...

You use the com objects (c++ or vb) provided in the job api. I just use excel and it's forms as a front end to manage the parameters. Parameter values are not stored in the job executable. I can open the job, change values for parameters, and save the job without compiling it using the api *********...

Thanks for the reply. I have done the flat file thing in the past. In my experience that requires that I have a wrapper job that calls the job. Too many jobs to deal with. In the mean time I have written an excel addin that helps me manage parameters. Looking at the parameter manager product but won...

Has anyone written any utilities to change stage passwords (parameters used) in DataStage with the Job API? Our shop has a requirement to change database logins every 45 days. Thanks for any input.