DSXchange

Ja, check this link out. There's plenty of info on timestamps.

viewtopic.php?t=95920&postdays=0&postor ... mp&start=0

Can anyone give a command to kill the job from DS admin? I doubt it very much. You could try "UNLOCK ALL" but this usually only works in the uv account of datastage. You could possibly knock up a paragraph function here, but its probably out of scope of this discussion. You need to run th...

Yo Gateleys

In past situations like this I've used left outer join to collect ALL the (sorted) dates related to the RefID and then used a transformer to constrain the data I dont require. Sweet.

It's been a long time since I rock and rolled. Actually I'm working on mainframe at the moment and we don't have access to DB2 so I cant test this solution anymore. As far as I remember, I simply switched the value of column IBMREQD between 'Y' and 'N' and did the sparse lookup again. Go for it, thi...

Try rejecting your data into a dataset instead of a sequential file. Sounds like your delimiter settings in your sequential file are not initialised properly. Also be aware of nulls and use an explicit NullToValue conversion on nullable fields.

I just set up an XML reader with namespace in Xpath and it was the only way I could get it to work, so I figured I'd add to the best post on the subject.

Caption definitetly says its "poblem" and I cant bare bad speling.

Ok... hard to get too specific with someone new to XML, and I'm not exactly an expert on it. :( In the 'definitions at the top' are there any 'namespace' or 'xmlns' entries? Did you include that in your metadata import? If so, then you'll need to load that information into the XML Input stage... yo...

We had a change in the structure of an idoc being read into server with a new field being added. Meta data imported ok but when we ran the job, the following error message appeared: GOWIL_TR: IDoc exception: CIDocMetaDataTree::FindField(): No metadata available for the fieldPACKED_QTY' Our work arou...

There's probably some other cool Julian date functions out there, but here's a quick solution: dj = '2006346' oconv(iconv(dj[1,4]:'/01/01','d/ymd[4,2,2]') + dj[5,3],'d/ymd[4,2,2]') This simply adds internal days at 1st January 2006 plus julian days since (346) and outputs in the format d/ymd[4,2,2]....

Use an aggregator

So now we are expected to pay for this forum? Sorry, I wont be party to this. I've worked hard to give honest advise and examples to help build this forum mainly because it was free for everyone to use.

This changes the ethos, I think dsxchange should reconsider else this will remain my last post.

Click on the "Command" option in your project in Administrator. Making these commands job specific simply requires entering the name of the object you wish to update i.e. UPDATE DS_JOBOBJECTS SET READONLY = 'RO' WHERE NAME = 'JOBNAME' ; or UPDATE DS_JOBOBJECTS SET READONLY = 'NRO' WHERE NA...

XML can handle repeating groups, but only one i.e. You can Have: <parent> <child> <child> But not: <parent> <son> <son> <daughter> <daughter> I've happily been using MQ on a NT based install of DS. I'm pretty sure this plugin is available for all platforms.

Assuming you clear the directory after use, I'd use a bit of BASIC here, combined with UNIX so you'd get something like: CMD = 'ls /incoming/data' LOOP CALL DSExecute('UNIX',CMD,o1,o2) UNTIL o1 <> '' DO SLEEP 60 REPEAT * Setup unix_cat, run it, wait for it to finish, and test for success hJob1 = DSA...

Hello, I'm taking a punt here to guess that the datastage engine user, eg dsadm does not have permission to access your MQ. If you give dsadm that privelege, MQ should work for you. You can prove MQ is working by manually accessing it from the MQ manager.