DSXchange

At my source along with sequential file one more database stage(oracle) is there . The problem is not at transformer that is at the source database stage while I am clicking the get SQL INFO .It is giving this error DSR.MetaGeta(GET.DSNINFO)(SQLConnect('SHR2','PARAM1328')): BCI Error: SQLSTATE=IM004...

Hi, In my job I have 4 sequential files and all the sequential files having nearly 15 columns and i need to get 3 columns from each sequential file and get into my source database table(Oracle 9i) and I want to create the table at the datastage itself with out touching the database at all. I am gett...

ok i agree with that, then what about the input page in folder stage when we are going to use that. in which way, there why we need to specify the folder path as in input page.

Yes i read the documentation but i didn't get wht it is saying about input page.

Hai Gurus,

Here is problem about Folder. iam going to load 3 files into one folder which is immplemented by folder stage.

But the error giving is at stage properties the folder path is not taking. plz give the method in which way i have to insert files into the folder.

I have a data in flat files containing only one column of type char(10) in the following format yyyy-mm-dd.

i want to transfor it into oracle thru odbc in the oracle specified date format (dd-mon-yy).

plz any body give the conversion code

this is the sql code i excuted which is a sample table only under UV TELNET CODE PA HUSH OFF COMO ON BUILD.LOG DROP TABLE EMPLOYEES; CREATE TABLE EMPLOYEES (_ EMPNO NUMERIC(4) NOT NULL PRIMARY KEY,_ ENAME CHAR(10),_ JOB CHAR(9),_ MGR NUMERIC(4) CONSTRAINT EMP_SELF_KEY REFERENCES EMPLOYEES (EMPNO),_ ...

yeah , Finally i got the tables data into my universe stage. as i am kid in datastage with 14months of experience. i dont know in which way i got the data into the stage. i will explain what i done will any body plz explain how it is working. 1.First i devloped a sql script with first field PA and n...

no i didn't created any local uv
its already there .

before going to run my sql script. how i can copy to telnet environment .

what i mean is how can i load tables with out copy the sql script to voc at telnet is there any alternate way.

my question is how to load data into my local uv

Hai gurus I am new to DSXchange. Here is my problem (some what lengthly) just i created a Universal DB(local database) thru Access to ODBC thru BCI like this DBMSTYPE = UNIVERSE network = TCP/IP service = uvserver host = 127.0.0.1 next i developed a sql script for tables and records for my local db ...