DSXchange

RCP is Disable.We not enabling the RCP

I'm using Data stage 8.5.Oracle 10 My SRC is Oracle here I've 60 fields but only 1 field having Varchar2(1000) in SRC.due to this I'm getting above error If I remove this field job working fine. SRC_Field Varchar2(1000) I'm loading into Trg_Field Varchar2(4000) To read this job I tried Varchar ,Long...

Hi All, Can you please help the bellow issue. Job Description: (Oracle Db) reading with(ODBC Conn) both source and target and we creating generic this should word for DB like Oracle DB and DB2 etc.so that we using ODBC Conn. Job: ODBCConn------->Transformer--------->ODBC Conn (strt move) Error:TrgOD...

Can you please tell me how the issue is resolve

Hi... When I run the job it is giving the following warnings ========== main_program: **** Startup error on node1 connecting with conductor on COMPNAME with cookie 1276456058.429000.1628: unable to connect to port 10000 on conductor; socket = 4, Connection refused retries left: 3 main_program: ****...

Hi All, Job design: Job -1) Mainframe-------Transformer----------Sequential(Its ok) Job-2) Sequential file------>Transformer------->Oracle stage In secon job I getting below wanring and error Wanring:Vijaykumar Tumati: Sequential_File_29,0: Import consumed only 161bytes of the record's 169 bytes (no...

Hi Mark,

Now I'm working Lotus notes migration project.can you please explain me couple of questions.

1)Lotus files are .nsf files rite.To read those file what is the sour stage you used?

2)Did used any ODBC drivers?

3)If you followed any process.please can you explain its helps me alot

Hi Mark,
Did solve Lotus notes problem? Now I'm also working same Lotus noted is my source can u plz help me.

Hi Friends, I've column "Comment" in my source.I'm getting approximately 10000 character for that column.while reading the data from sequential file I'm getting below error. <SF_Profiledb,0> Error reading on import. <SF_Profiledb,0> Consumed more than 100000 bytes looking for record delimi...

Hi Friends,

I have column "Comment" in my source I'm getting 8000 character for that column.
Can datastage support 8000 character for in cloumn. ?
what is the max datatype for VarChar fields in datastage?

Hi....... In my source contains 9 records. Id,Org_Name,Websit,Comment_c,Client_Id,....... In the above MetaData Coment_c filed size 3200 bits,This field comment about the client.While enter the comment if user press enter button then sequential file consider as newline character from enter position ...

Hi Friend. I've one file it contains 9 records(EceptionDb).If I open file with .csv format then I can able see 9 records.then I design a job I use the sequential file as source Simple I loading in target.While reading data It showing 26 records but actually it contains 9 records. So sequential file ...

Hello Friends,

what are the stages can read .csv file ?whats the best way?

chulett wrote:Curious what you think is going to happen to your poor Windows server when you attempt to start 100 jobs (parallel or otherwise) at anything approximating the same time?

My QUESTION IS HOW I DESIGN 100 JOB IN ONE SEQUENCE ?


I'M NEW TO SEQUENCES?

Helo Friends,


In my project I've requirement like...

I develop 100 jobs all independent each other(no dependency) But I need to design one sequence to trigger all jobs at a time.

Thanks.....!!
VijayKumar T