DSXchange

Michael, You are right.Space on datasatge server is full. My datastage server installed on Wndows Sever SADW(E:drive).Recently we added 100 GB to Windows server SADW(F:drive). Why datastage server is not taking space from F:drive(added space)? What are the steps do i take to recognise F:drive by dat...

Hi, I am loading data into hash file from ODBC table.After 465000 rows the job was aborted because of the following error "LoadHashedFiles.parthsh.DSLink26: ds_uvput() - Write failed for record id 'PS182496L-APC-APFC-BRFXS'" Key field in tha hash file is part_num,datatype VARCHAR and size ...

Hi,

The source columns are Custno,year,month,dol1,....dol31 n take for example i loaded data today.I need to load data every week ...could u guide where do i put WHERE CLAUSE ??? n on which column??

Brian,
I need to schedule this jon on WINDOWS.
I tried update action "insert rows without clearing",its simply inserting all the records into target i.e i am getting dupliacte rows in staging table.

Probably u can find documentation with software i.e release notes

Brain, I was connecting to DB2 using ODBC DSN. IT people load data every week(simply they are inserting rows into their system as is).I loaded history data till 09/30/2004, now i want to load only data between the 10/01/2004(eventough source system contains all the previous data) n would like to sch...

Hi ALL,

I am directly extracting data from AS/400 DB2 Database.(Usually somebody will extract the data from DB2 n give it to us weekly or daily or monthly basis).Here i need to set up all the jobs on weekly basis,how do i design that job?

Thanks,
Ram.

Yeh its timestamp.I checked archives but there is no clue.

Ram.

Hi,

I tried to load Binary Datatype(From Db2) to Sqlserver database binary datatype but i couldn't see any data in sqlserver database(all values <binary>).Is there any function to use ??

Regds,
Ram.

Hi All,

I was trying to load AS/400 DD2 date(YYYY-MM-DD) to SQLSERVER Database(Datetime) i am getting datetime overfolw error eventhough i used Oconv(Iconv,"D-YMD[4,2,2]),"D-YMD[4,2,2]").

ANy help...

Thanks,
Ram.

Hi,
We created ODBC DSN for AS/400 system on datastage server,I tried to connect AS/400 by using this DSN i am getting the following error:
DSR.MetaGeta: Cannot read result file DS_METATEMP record METAGETA-4584 from GetMetaData.Could anybody know what that error means??

Thanks,
Ram.

Hi all,

Is there any way i can conncet to AS/400 using datastage ODBC satge? If possible pls let me know how to connect(what r all parameters we set).


Thanks,
Ram.

I did login again to datastage,I got the same error.Is there any limitations on datastage 4.2 version with No.of columns in a table(my table is around 320 colums).


Thanks,
Ram

Hi All,

My source is sequential stage n target is ODBC table.When i compiled my job i am getting the following error.


Error calling subroutine: DSR_RECORD (Action=2); check DataStage is set up correctly in project 'name'
(Internal Error (81021)).Anybody have any idea about this error?

Thanks,
Ram

I tried to insert data into sqlserver table from sequential file.I am getting the following error: shipto.CODBCStage6.DSLink7: DSD.BCIOpenW results of SQLColAttributes(Company_Nbr) gave MetaData mismatch COLUMN.PRECISION Expected = 3 Actual = 10. I created table in sqlserver database using create ta...