DSXchange

Is this the first time you've ever received this error, or is this the first time you've ever used this stage (new installation of DS)?

Please paste the exact error message text and tell us how you setup the stage.

Yes it's possible but you would never want to do it. Job numbers change on a job each time it is imported. Furthermore, you would have to know and program DS BASIC rather well in order to bypass the API and the command line tool. The command line dsjob allows you to write in your own language all of...

1. How do you measure failure? No mattered how it was measured, the end-users were dissatisfied to such a degree that they did not use the data. 2. What is your definition of failed? Exactly that, end-users won't use it. 3. Why did it fail? Politics. The initial architecture could not be budged, eve...

True, you can't pick and choose groups of rows out of a data set to commit and others to rollback. If you're using Server to do something like that, you're probably using the wrong flavour of the tool. Probably the TX side of the house handles that type of processing better. Server and PX are aimed ...

Sometimes shutting down the engine could hang that process out there if there were clients still attached. For both Unix and Windoze it's a bad idea to simple shutdown services without first clearing out all attached clients and making sure jobs are stopped. Unix DS pros are familiar with DS hanging...

We can help you further if you more clearly explain your requirements with an example of data. Ray's not the only one who can help you.

Okay, okay, I completed my thought but failed to type it all in. 0 commit means commit at the end, any db rejects require a reject link, with an abort after setting to blowup the job after N links. As standard practice I always require absolute perfect db work so setting abort after to 1 is a standa...

Try zero. It means all or nothing.

On a reference lookup, the user defined SQL is not executed to do the view data. How could it? You have to feed it values because it is meant to pickout a row from the table. Instead, a select statement is automatically generated using just the column names in the metadata. That statement is roughly...

I am trying to figure out that how can I pass those value from a flat file into OCI sql. As arguments? You can't do that. The SQL is prepared, you cannot have dynamic or different SQL statement with each row. Ex: SQL statement = delete from fred where col1=':1' Your file contains different values f...

Any adversity to simply executing a unix command call to sqlplus running a script with the statement "TRUNCATE TABLE drop storage;"?

Any reason to use ODBC over OCI? If you can do tnsping from the unix prompt then it obviously means that the server has the Oracle sqlnet client installed. Why not configure DS for Oracle OCI and skip the ODBC stage altogether?

Or perhaps via a second link - which should be the first link sent to the stage when checking row order. Constrain it to only send one row (if appropriate) and you may need to commit the deletes before you do the insert to avoid locking yourself. Check his delete statement, it's doing a WHERE claus...

Well, you can't do that. The SQL is bound, it's not a place to write a script. If you need to execute a delete statement, then do it either as before-SQL or using a command execution of OSQL.

Where did your SQL statement originate? Is is generated or user-defined? Something looks fishy with your SQL.