DSXchange

In the time it took to type in your ASAP question, you could have used the Search facility and found the answer yourself. Your lack of knowledge of Oracle date handling will be greatly reduced if you spend a few minutes researching and learning rather than posting ASAP requests when single issues co...

Opening and saving a routine without compiling actually removes the compiled code. Jobs using that routine will fail because the compiled code is now missing.

Maybe during your drag and drop you opened the routine. Even saving-as another name doesn't copy the compiled code.

Change: CONTACT_FIRST_NM = :4 OR (:4 IS NULL AND CONTACT_FIRST_NM IS NULL to NVL(CONTACT_FIRST_NM, 'xxxxxx') = :4 and put into the derivation of the key expression mapping value for CONTACT_FIRST_NM If ISNULL(inlink.CONTACT_FIRST_NM) Then 'xxxxxx' Else inlink.CONTACT_FIRST_NM You...

Excel files are not supported as a file type. Delimited files such as a .csv are supported, but if you need to access Excel data either save it as a .csv file or link the Excel file into SQL-Server and setup an ODBC connection to SQL-Server.

In your routine use the DSExecute API to run system commands. By running sqlplus with the appropriate information you can get the results and error checking you desire.

Are you in a protected project? Are you trying to move between projects?

Goto to DS Manager, go to the folder you want, select all jobs and right-click choose "Move-to ..." and type in the new category.

If the category already exists, just drag and drop.

Execute a "touch /here/yourfilename" to create an empty file prior to running the job that expects the files. If the file exists, nothing happens to the data. If the file doesn't exist, a 0 byte file is created.

Any usage of that primary key as a foreign key needs to be handled. If you have a parent-child relationship with tables, you shouldn't have orphans after you change the primary key value.

Are you sure this is what you need to do?

Whatever you build into the script can pass the appropriate error codes back to DS. Non-zero return codes from shell scripts can generate a fatal error if you like. It's up to you to write a robust script that error checks the stored procedure and sets the proper script return code.

If you are trying to use the FTP stage to copy a binary file from the mainframe to the server and retain it as a binary file, then I suggest you use the command line version of FTP to do the copy. The FTP stage is trying to read the file with row delimiters, which you don't have, it's binary not seq...

The metadata that defines the column definitions of the source data does not match that in the actual source data.

Are you monitoring the server load to determine if your timeouts were actually caused by significant load on the machine? When you divide your processing across more cpus, you introduced more overhead to the machine as well as opened up your process to certain issues. If you can, please use top or p...

One method is to write a .bat script using the command line interface to your unnamed database. If Oracle, I suggest using sqplus, if SQL-Server, OSQL/ISQL is a good choice.

Use the script in the before/after transformer/job routine call of ExecDOS.

There is no such concept in a hash file of delimited or fixed width data. The S is for specialized Universe data sources that have multi or sub-multi-valued data. Ignore it.