DSXchange

Why in the world are you sending bind variables to the select statement? Remove the colon sign before TO_CHAR

Execution cannot be disabled, it can be constrained using a bunch of ways, including ones you mentioned. But it will be executed. Its not synonymous to C's #Ifdef and #ifndef.

You can build a portion, test it, build another portion, test it. What exactly is the bottleneck. Share your design and system info with us. What you are trying to do etc.
You cannot selectively disable links and stages, other than sending nothing down a stream, using @FALSE constraint.

I am confused. The phenomenon your are mentioning in C is during coding. You cannot code like that within constraints and stage variables. In a basic routine you have $DEFINE, $IFDEF, $ENDIF etc. which are listed in the BASIC.pdf that gets shipped with the product. You can go through it. If you expe...

Start over. Please supply the following:
- Source metadata
- Source sql
- Target metadata
- Target sql
- Job Design.

Try the following

Now, you need to change OPEN to OPENPATH in the first line of the code that you provided, as now your working with pathed hashed files.

An insert is a DML statement. It will be a logged activity. A bulk load is not the same as insert. So you want to test the inserts. Take the same sets of data and test it out. It does not depend upon how many years of data you have. It depends upon a lot of factors like record byte size, netword tra...

OCI stage will not allow you to perform bulk loads as this option is not there in the OCI stage. Only with the ORA Bulk stage, which leverages the database's bulk load utility.
As for your error, search on the ORA code in google.

Did not pay attention to the forum, my bad.

I dont see the connection in the dates. Is it the closest one to the incoming date ? Either way its a range lookup. Search the forums for advice on how to tackle range lookups.

Specifically thispost.

On what basis do you want Record 2?

Reference thiswebsite for logic. Incorporate that in a few lines of code in a routine. You can also do it in a stage variable.

If you were to run a sql command from unix command line, how would you do that for sybase?
Wrap that in DSExecute() and you have yourself a routine. Search the forum for specific examples of how to use DSExecute().