DSXchange

Do a search on orchoracle. I have provided detailed steps how to fix this problem.. I did the search and could find nothing relating specifically to the libcIntsh.so file being empty after installation. I found the post I think that you're referring to, I believe it starts: Are you running 7.5x2 EE...

Hi all, I have searched on this, but could not find the specific problem previously listed, so here goes... We recently had IBM complete a new installation of DataStage version 8 on a Linux OS. Following the installation, the consultant ran serveral test jobs, one of which was to use the Oracle Ente...

OK...

- It's Friday afternoon
- I had a late night in the pub last night
- I took a 12 hour flight two days ago and am still jet lagged



Yep, supplying a Routine Name was all I needed to do

Thanks chulett, much appreciated.

Cheers,
S

Hi All,

I am trying to create a new Server Routine, but when I open up the new routine Window, the Code tab is greyed (grayed) out.

This is happening for all users, including dsadm.

Any ideas much appreciated.

Thanks in advance.
S

Hi All, The XSD schemas we use contain imports of other XSDs which result in several being embedded together. The XML Meta Data Importer had problems with multi-file XSDs and this resulted in xpaths that were not correct and that could not be satisfied. Furthermore, there were lots of odd duplicatio...

Just to add..

The XML file validates against the schema in Liquid XML Studio. I have tried removing the default namespace prefixes, but to no avail.

I have now raised this with IBM support and will post up if I manage to resolve the issue.

Cheers,
S

Hi Ernie, Job has 4 stages: External Source ===> XML_Input ===> Dataset || Rejects The job reads in an XML file (using the 'ls' command in the External Source stage), parses it in XML input and writes to a Dataset. The job works fine in another application, but for this job I have amended the table ...

Hello All, I have a job that is designed to parse XML and write to a dataset. The job is based on another which is working fine, but the table definition has changed. I use the External Source stage to read in the XML source file. There are several namespaces declared. When I run the job it fails, p...

Whomever was transferring the file would need to do that, post transfer. You can't, unless you first check to ensure the file is completely transferred, and if you do that we're back where we started. :wink: Ah, got you - so the 'mv' would be issues by whatever application posted the file. I'm ther...

I use a different approach (on linux and unix plattforms) and that is when any file has been ftp:d or written to a specific directory , say /arrival. On completion the file(s) are moved (using mv) to another directory where datastage is listing for files, say /complete. Datastage then moves any fil...

Thanks very much for that ArndW - another top tip!

Cheers,
S

chulett wrote:I prefer the semaphore approach.

Thanks for the quick reply and your time Craig - I'll try and work the semaphore approach into my plan. :D

Cheers
S

Hello All, I have a sequence that runs sub-sequences once files are in place in a specified directory. I am using a routine for this, as specified by Ray Wurlod at this link http://www.dsxchange.com/viewtopic.php?t=115198&highlight=wait+file+wildcard - thanks Ray! I cannot use Wait For File beca...

ray.wurlod wrote:There will be some upper limit to the size of numbers you can convert using ordinary arithmetic, ...Premium Stuff

Oh - and thanks very much for this Ray.

Regards,
S

ray.wurlod wrote:Did you ask WHY there is this requirement?

The DS process will be replacing an existing process, and these codes are historically stored as base-36. Presume it is just space saving..

Cheers
S