DSXchange

Could be lotsa things...has XMLInput Stage ever worked for you? Have you looked thru the forum here for XML examples? Try something simple first...the XML Stages can be a bit tricky first time you use them..... Ernie This is first time i m using XML input. I searched all the forums. Created the job...

Hi

i tried loading an XML file into a sequential file.
its throwing the fatal error as:

XML_InvoiceShip_Input,0: Error occurred in call to ORPHCallActivePluginInitialize().

Can someone help me regarding this.

Thanks in advance.

Hi

Can you help me:
1.How to read messages from IBM WebSphere MQ using Datastage.
2.Which is the stage we have to use.
3.Any basic and advanced material of uisng this.

Thanks

Hi how to convert string to timestamp in transformer.
Can you help me with an example.

I tried this:
StringToTimestamp(link name,["%yyyy-%mm-%dd %hh:%nn:%ss"])

but its giving me a parse error.
may be i am missing something here.

No workaround since the issue's cause hasn't been identified. What about the answers to the second question - is this a new problem or did it work before? Does it affect just this job/table/database? ... This is a new problem. There is a sequence with 7 jobs in it. l1,l2,l3,l4,l5,l6,l7. The job l4 ...

ArndW wrote:Can you do a "DB2 connect" from a command line to this instance? Is this a new error or a new installation? ...

I checked the DB2 instance and its connecting.
Any workaround to solve this issue.

Hi I am getting the below error. DB2EffPrcc,0: Fatal Error: Fatal: [IBM][CLI Driver] SQL1224N A database agent could not be started to service a request, or was terminated as a result of a database system shutdown or a force command. SQLSTATE=55032 [IBM][CLI Driver] SQL1224N A database agent could n...

Hi

We have a parallel job where target is sequnetial file.
We need to FTP this sequential file along with the column names to a remote location.

Can u please help me.

Thanks in advance.

us1aslam1us wrote:First check you APT_ORACLE_LOAD_OPTIONS environment variable. If still problem persists then discuss this with your DBA.

I have checked APT_ORACLE_LOAD_OPTIONS, there is no value for it.

Need more information. what does the log suggest ? Also does the user have access to the table? Check any constraints on the table. i m able to insert a row externally using a insert command. When i m running the Datastage job.......its not loading. There is no error in the log file. Its taking a l...

Hi ,

I have a dataset with 4 lac reocrds.
i am loading to a oracle table.
there is no transforamtion....involved.

But.......i m unable to load a single record.
the table is also empty.
Awating ur reply.

Thanks in advance........

Could you please let me know whether Datastage Server and Parallel support oredb?

OREDB:
It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base.

Which one supports this OREDB.

Thanks,
Pavan

chulett wrote: Now you've lost me, what would be the point of that? It's already 'in a sequential file'. However... read / write it as one long varchar column. ...

Thanks.
Now you can see a column called 'Rejects'.
If the rejects are >0, i have to send a mail.
how can i do this in datastage.

chulett wrote: Now you've lost me, what would be the point of that? It's already 'in a sequential file'. However... read / write it as one long varchar column. ...

Thanks.
Now you can see a column called 'Rejects'.
If the rejects are >0, i have to send a mail.
how can i do this in datastage.

chulett wrote:Sure, read it as one long varchar column then parse as appropriate. The question is what data do you need to 'extract' from it? ...

I want to extract the file as it is and load into a sequential file.