DSXchange

chars = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ" lenChars = LEN(chars) ;! Check if ok to convert to this base... If nbase < 2 or nbase > lenChars Then Return('') End r = '' newNumber = '' ;! r contains offset of char that was converted to new base Loop r = MOD(num,nbase) newNumber = chars[r...

I would wager you'll need to roll your own conversion. Before reading this, I thought it was a typo as 3x16 is 48 not 36... so, sexatrigesimal? :lol: Spot on! :lol: The most common latinate name for base 36 seems to be hexatridecimal, although sexatrigesimal would arguably be more correct." Fr...

Hi All,

Part of a requirement I have is to store a number in hexatridecimal format (also known as base 36). Do you know if there are any built-in functions/routines in DataStage that will allow me to do this... or will it need to be something bespoke?

Many thanks in advance.

S

Great - thanks very much for ther pointers. :)

Cheers,
S

Hi All, Probably a simple one for you gurus out there, but it's been a long day here... Basically, I have the following row: <OpenTag attritbute"888"><SecondOpenTag> As part of my processing, I am splitting up the XML and don't want the second open tag... So, what I want to do is: Trim(Inp...

This usually means that your xpath expressions don't match the incoming XML document. Worth double checking them.

How did you create the xpaths - XML Meta Data Importer?

Cheers,
Stu

External Source Stage worked perfectly - Ernie, you are a hero, thanks.

Cheers
S

Did it reproduce after restart? Sadly, yes :? Some more information... The job uses a Sequential file as input and within that file is the full path and file name of the input XML. The file is declared as: * Record Type=Impicit * Field Delimiter=whitespace The contents are '/myFilepath/myInput.xml ...

Hi Ernie,

Restarting in 10 mins, will post back and let you know.

Thanks for looking in.

Hello All, I have a job that up until today was running happily and producing the desired results. The job goes: Seq File =====> XML_Input =====> Dataset The sequential file contains the full path to the input XML document. I ran the job today, with the same inputs, parameters etc as before, and it ...

Hi All, OK, I went back to basics and took out the fields to update before adding them back one by one and running. I have now managed to find the source of the problem... I had a timeStamp field that on the input contained '***********' which caused the invalid time message. Basically, this was dow...

Thanks for your reply Ray. The ODBC table definition was imported from the target Oracle table. This is one of the peculiar things - viewing the table definition in the repository, two of the fields appear as: FieldOne - Double(15) FieldTwo - Decimal(38,0) However, if I load the tab defn from the re...

Hi All, I have a Parallel job that is loading data from a Dataset to an Oracle table using the Enterprise ODBC stage. The job compiles fine, but is aborting at runtime with multiple fatal messages. The job goes: dataset ----> Transformer ----> Enterprise ODBC The table definition used in the ODBC st...

Hi All, I did a search on this, but although 3 topics came up, none showed a resolution... I have an EE job that takes data from a dataset and passes through a Transformer, then loads it to an Oracle DB using the ODBC stage. To get the table definition for the input to the ODBC stage, I imported dir...

Check the Parallel job compiler options in the project's Environment Variables (using Administrator) to ensure that they are identical for both the old and new environments. Are both servers using the same OS?

Regards,
S