DSXchange

Hi Chulett,

In oracle database column size is [20][4] Number.

ArndW,
Currently i am using like that only.

Call the routine using Routine Activity, and Introduce a Job Activity and call the actual job. The job activity will show all the available job parameters. For the parameter you are interested in, select the Routine Activity.$returnvalue

Resolved, Sent a mail to membership.director@dsxchange.com and it was taken care.

I renewed my membership last week, but it didn't become effective. Now my membership has expired. I have sent reminder mails to rick@dsxchange.net, but no response.

Any idea whom to contact, and how to proceed now?

In our project all the hashed files were created using Directory path option, and so all the hashed files were created in different directory apart from the project folder. Suddenly, we found out all the dictionary items (D_* files) were missing from the hashed file directory, and we have restored t...

We are installing 8.1 Version with NLS option enabled. We have inspected the Installation logs files. It shows some warnings related to NLS and the following error messages Aug 22, 2011 4:38:17 AM , INFO: com.ibm.is.install.core.DSUnixProcess IInstallCore90002:Command: sh nls.install, env = [ASBHOM...

Have anyone faced similar issues while installing IBM Information Server on OEL Linux OS Servers.. Please post your suggestions on this issue

We have installed Services and Metadata Repository on one Server. In this server the installation went fine without any issues. We installed ENGINE on another server. Installation completed successfully but the default project was not created. Also Projects folder was also not created under /ds1/pr...

Thanks Ray

Our IT Team has raised some security concerns about the information published by TELNET banner. They want to know 1) What is the purpose of Telnet Service, Why it is required for IBM Infosphere Server? 2) Can we disable the Telnet Service in the Server? And My understanding on telnet Service is, it ...

Hi Ray,

For my Target i am using DRS stage,so i am using the meta SQL %DateTimeIn() ,which doesn't handle the microseconds part.

So we tried like %DateTimeIn()%Concat(Microseconds),but we got the error as "ORA-01849: hour must be between 1 and 12"

Hi,

can any one tell us how to covert a timestamp field which contains microseconds in it.

My input is coming as :25-MAY-10 01.19.11.968986 PM

we want Output in the format of 2010-05-25 13:19:11.968986

How to handle micro seconds conversion.

Just replace the space with Char(10), you will get your required output.
I didnt test this code, please do the required changes.

Get the jobnames from DS_JOBS from both the projects and compare it in excel or anyother tool. SELECT NAME FROM DS_JOBS WHERE NAME NOT LIKE '\\%'; You can use this query either in universe stage or you can use it in Administrator Command prompt directly. For saving the results from Adminstrator Comm...

Welcome to Dsxchange.

You have posted the question in wrong forum, Please post it in correct forum to get appropriate answers.