DSXchange

Getting the following error :


Jul 14, 2012 10:59:11 AM, WARNING: com.ibm.is.install.ui.web.JettyWebContainer /ISInstall java.lang.RuntimeException: java.lang.UnsatisfiedLinkError: awt (An exception was pending after running JNI_OnLoad)


Any ideas please....

Yeah I actually did.. it does not say which version of WAS is bundled within the Information Server installable.

I am planning to install DataStage 8.7, I have a few questions on it : 1. What is the default version of WAS which comes with the DataStage install 2. Do I have install WAS Separately and then install DataStage or can I just install the services tier along with DataStage install ? Any help in this r...

Hello All, I am new to the MQ Connector Stage , I am trying to understand if we require Information Services Director in order to use the MQ Connector Stages in real time mode(always-on jobs) ? Do we have to buy license to run the job 24x7 or do we have settings in the MQ Connector Stages itself whi...

Hello All, I am new to the MQ Connector Stage , I am trying to understand if we require Information Services Director in order to use the MQ Connector Stages in real time mode(always-on jobs) ? Do we have to buy license to run the job 24x7 or do we have settings in the MQ Connector Stages itself whi...

Created a CHECKSUM based on the keys and then used a stage variable in the Transformer stage and concatenated the strings. And used a remove duplicates stage to retain the last one.

052288064081042322OCT08TUL300AA3151MAINT ENTRY. AIRCRAFT NEEDS LMP DOWNGRADE DUE TO AUTOLAND IN 60 DAYS ******************** MEL 052288064081042322OCT08TUL300AA3151 *RESTR TO CAT I*. DUE TO 60 DAY EXCEEDENCE OF THE F.C.C The key here is 052288064081042322OCT08TUL300AA3151 based on this I wanted to c...

Sreenivasulu wrote:You can read excel (with some limitations like - no macros ) using a java api . Register the .so in the unx box.

Regards
Sreeni

Hi Sreeni,

Can you point me towards some Java API.

Regards,
Ganesh

Hi,

I have a requirement to load attachments like MS Word , Excels or emails to SQL Server. Anybody have any advice on how to do it.

ray.wurlod wrote:And that only took you three months?!! Amazing! What else have you tried? ...

I actually started following this topic today.. trying to figure out what the exact date should look like from the source..

If this is true you can use StringToDate() with an appropriate date format mask string. ... Hi Ray, I tried using the following format : StringToDate(DSLink2.flm[12,5],"%yy%(ddd,v)") but am getting the warning : Transformer_9,0: Conversion error calling conversion routine date_from_ustrin...

If this is true you can use StringToDate() with an appropriate date format mask string. ... Hi Ray, I tried using the following format : StringToDate(DSLink2.flm[12,5],"%yy%(ddd,v)") but am getting the warning : Transformer_9,0: Conversion error calling conversion routine date_from_ustrin...

mjgmc wrote:I found the answer I was looking for.

Can you please let me know what the resolution was?

Yes when I read the entire record as a single Varchar column, it works fine. Thank you Ray, I will trying to parse it in the transformer stage and update how it goes...

Yes when I od -c filename , I do see a \n at the end of the first line. That is why I have used a record delimiter as UNIX newline.