DSXchange

Thanks for replying back.

Stage type :- Oracle Enterprise
Stage Settings :-
--------------------
Lookup Type-- Normal
Read method -- Table
Table-- "Table Name"

dboption Mode-- Auto Generated

Thanks

DataStage -- 8.1 Database -- Oracle 10g OS -- Unix I have a DataStage job (FCT) which is doing a lookup based on two keys columns to the DIM table. This job ABORTED with the following error message. ------------------------------ "main_program: (aptoci.C:483). Message: ORA-04020: deadlock detec...

Hi, Thanks for all the replies...

I solved this as follow:

credentials file contents :-

mac100:9080,MAC100,dsuser,dspwd

i.e, domain,server,user,password

and used the following command

dsjob -file credentials.txt mac100:9080 MAC100 -ljobs MY_PROJECT

Thanks again for your help

Thanks for your reply. I tried file but it's still the same issue . I even used ; to terminate every line in credential file. Please advice .

Hi All, Environment -- Windows Server, Datastage 8.01 I am trying to use dsjob command using text file which contains the username, password and server details. But its not working and produces the error "invalid/unknown primary command switch" , with status code = -9999 DSJE_DSJOB_ERROR. ...

Thanks for your reply. Let me clear my problem again. Have some files like 01012011abc.txt, 02012011abc.txt, 03012011abc.txt, 04012011abc.txt and these files keep on increasing on daily bases. I Have a job which extracts the data from these files and put in a table. Let say my first file have 5 reco...

Hi All, I have a list of files in unix. All the file names are in the format "somedate+abc.txt". eg 12062011abc.txt, 13062011abc.txt, 14062011abc.txt and so on. I want to design a datastage job which will read these file NAMES and put the names (NOT CONTENTS) in a oracle table OR a comma s...

My source file is very huge contains nearly 50000 records with around 100 Columns. If i give only 500 records in the source file then the job runs fine. So something causing problem when i use complete file.

Any help ?

I m trying to read a huge CSV file. Got following error. Any help how to fix this. Please suggest what settings i need to change. ##E IIS-DSEE-TOIX-00158 23:00:10(000) <Sequential_File_Read,0> Error reading on import. >##E IIS-DSEE-TFRS-00061 23:00:10(001) <Sequential_File_Read,0> Consumed more than...

blewip wrote:This has to be fixed in the input file.

Possibly use a different delimiter.

DataStage cannot guess which is the delemiter and which is data.

Any other suggestion plz. I m not allowed to change source file at all.
Thanks

Is the <non-delimiter> comma always present in the column, or just sometimes? If always present, one workaround is to just adjust the schema to import that column as two columns and then concatenate them later in a transformer. If no always present, read the entire record as a single column (sugges...

ray.wurlod wrote:Are the character strings quoted? ...

Thanks for reply...

NO .... Not Quoted...

Hi All,
I have a Flat file with comma as delimiter in the columns. I am reading data from this file using sequential file stage (Delimiter Comma). But the only problem is one of the column value includes comma in it. Don't know how to handle this. Any Help.
Thanks in advance.

Thanks for the reply...... It is excel sheet, data is entered in cells, some of the cell values are empty...but can't see any issue with the delimiters. Moreover it reads first fifteen records perfectly and ignore rest of the data with warning. The excel file format looks same from the first record ...

Hi All, I have an excel sheet, in this sheet i have a date column, i am trying to fetch the data from this sheet and storing this is db2 database. I have a problem in this , some of the dates in excel sheet are:- 1. written as 0 2. written in the format as mm/dd/yyyy. 3. written in the format m/dd/y...