DSXchange

I have 2 tables. Customer table and the attendance table. With these two tables I need to create a new table CUSTOMER_OUT. This customer_out table has columns derived from Customer table and attendance table. I had the impression that I can run multiple select statement and can derive the value. But...

At worst case, add it to your script - either that or put a fully pathed (instead of a relative one) reference to sqlplus there. These are my entries in dsenv ORACLE_HOME=/usr/oracle/product/9.2.0.6; export ORACLE_HOME PATH=$DF30DIR/bin:$PATH:$ORACLE_HOME/bin. You don't literally have a dot at the ...

sqlplus is not in the path for the DS engine process. Check the path in the dsenv file in the DSEngine directory. The DS engine was started without the path in the environment file that can find the Oracle binaries. Fix that and you fix your problems. The other method is to reference the binaries d...

Hi, I am running a simple shell script through Datastage as a BEFORE ROUTINE. This is the script. sqlplus -s username@engt1/password <<EOF execute useradmin.msp_loader.drop_index('rnkt0','attendance',null,'ALL'); EOF . I have put this in a shell script called drop_index.ksh and it is present in the ...

No, they are not one and the same - they perform similar functions, but for two totally different databases. So, if your target is Oracle you could use the ORABULK stage. Similarly, if your target is Red Brick you could use the RDBLOAD stage. Stick with command line sqlldr. Just because you've got ...

No, they are not one and the same - they perform similar functions, but for two totally different databases. So, if your target is Oracle you could use the ORABULK stage. Similarly, if your target is Red Brick you could use the RDBLOAD stage. Stick with command line sqlldr. Just because you've got ...

Hi, I was trying to bulk load a file with 5 million records.First thought I will do it by unix command line sqlldr command. Then since datastage has that facitlity I thought I will use that. I went through the help files which mentions to use ORABULK stage. But what we have is RED BRICK stage. Is th...

Instead of learning by self-doing, dear Prashanth, you should go into a DataStage Training Course and after the first day you cannot imagine any more having ever asked this question. Answer: Select the two tables in the OCI-Stage and write your where condition in the where tab, that is all. Kind re...

Hi, I am not sure whether this logic can be implemented using DS server job I have 3 oracle tables(I am using ORACLE OCI stage to represent them). My output table is called CUSTOMER OUT and the following are my input tables TABLE 1 TABLE 2 I have a column called CI(foreign key) in TABLE 1. This is t...

"ISO format" for dates means ISO 8601, which is an international standard for how to format dates, timestamps, times. The standard date format is YYYY-MM-DD. ISO8859 (various parts) is a standard relating to encoding of characters, and is irrelevant on this thread. NLS character maps don'...

Sorry I am new to the forum , that is the reason why i havent quoted properly. I wil try the way u have suggested

Dates are REALLY easy, you don't have to do most of the manipulations discussed on this thread. 1. Put all dates into ISO format YYYY-MM-DD during transformation. If you have a NULL value, THAT'S OKAY. However, whenever you manipulate your date into ISO, make sure you do it correctly. The time port...

In the USA, use MDY rather than DMY in the expression. Ray, I used the user defined sql and the only to get away with this error message is that. So I copied the generated sql and wherever there is a TO_DATE, I checked according to what I want and it worked.:-) Thanks One more small doubt, can I pu...

ray.wurlod wrote:In the USA, use MDY rather than DMY in the expression.

Ray,
I used the user defined sql and the only to get away with this error message is that. So I copied the generated sql and wherever there is a TO_DATE, I checked according to what I want and it worked.
Thanks

Leave the target format to be YYYY-MM-DD HH24:MI:SS. In the tranformer, include OConv(IConv(YourVarcharDateColumn, 'D/DMY[2.2,4]'), 'D-YMD[4,2,2]') : ' 00:00:00' Even I had the same problem and when I tried your logic it is giving me this error RNK_SEQOCI_V3_cus..Transformer_29: ORA-01843: not a va...