DSXchange

Yes, I already knew it was a UniVerse Multivalued DB and unfortunatly doesnt contain any DICT items for the file attributes. I am trying to write a Server Routine that will loop through all the RT_STATUSnn files and potentially set the status to Aborted/Restartable (for restatable jobs). I am aware ...

Hi,

Does anybody have any schema information on the RT_STATUSnn records or know where I can find it?

Cheers,
Joe.

@ sinhasaurabh014
I already tried as a file and same issue.

@ ArndW
I still get the same error when adding a "commit;".

I think I will have a to raise a ticket with IBM to investigate this one.
Thanks for your suggestions.

Cheers,
Joe.

Hi, I am having issues when I am executing a Before SQL file within the Teradata Connector. It is splitting the file up at ever semicolon, even if it appears in a comment or a quoted string. This works fine: UPDATE TABLE_A SET COL_1 = 'XYZ' WHERE COL_2 LIKE '%,%' ; This however doesnt work even thou...

Hi,

I was wondering if there is a way to append to a Lookup File Set?
I want to avoid recreating regularly as it may contain 100's of millions of records.

I am not opposed to another solution that doesn't use the Lookup File Set and that can perform quickly

Cheers,
Joseph Neasy.

Ok so I have created a reference table named AUSTATES and entered in the following rows for a start: "NEW SOUTH WALES" NSW "SOUTH AUSTRALIA" SA Now I'm a bit stuck with editing the Pattern file, is this the correct pattern to convert the words to their abreviated form? & CONV...

Hi, I have an address field I would like to standardise. the problem I have is I cant seem to perform a classification override for a mulitple words, for example I would like to standardise the words NEW SOUTH WALES to the abreviation of NSW. First off opening the existing AUAREA rule set and trying...

Thanks Craig!

I thought that might be the case but couldn't find any info or forum post to confirm.

Cheers,
Joseph Neasy

I have a question regarding Time() during Daylight Savings Time (DST) changes.

When DST ends and 2am occurs twice in the one day will the Time() function return '7200' twice?
Also when DST begins and 2am magically becomes 3am, does Time() return '10800'?

Cheers,
Joseph Neasy

Have you seen the following?

viewtopic.php?p=338081

Make sure you have scale of the column set to your desired value, i.e. 4.


Joseph Neasy.

This is definitely part of 8.7 and 9.1, I just checked the documentation. http://pic.dhe.ibm.com/infocenter/iisinfsv/v8r7/index.jsp?topic=%2Fcom.ibm.swg.im.iis.ds.cliapi.ref.doc%2Ftopics%2Freconstructaproject.html http://pic.dhe.ibm.com/infocenter/iisinfsv/v9r1/topic/com.ibm.swg.im.iis.ds.cliapi.ref...

You do need to remember to recompile all jobs, routines, etc.

Joseph Neasy.

Hi, I am currently working on an engagement where the client receives emails from various external sources into a single exchange mail box. These emails will contain XML attachments which the client would like to capture and pass through DS jobs. What would be the best method to capture the XML atta...

Hi, I got approx. 50% through an install of the Metadata Repository and Services Tiers for IIS8.7 on AIX7.1 Error message "The server seems to be temporarily unavailable. Would you like to retry?" options: OK or Cancel. when clicking on OK the same error keeps popping up. My question is wh...

Hi sarathcr, I'm still relatively new to DS but it looks like that the option "Output Row Only Once" set to true will output the row only to the first where clause it matches and wont remove duplicates. I would suggest using the "Remove Duplicates" stage and use DeptNo as the key.