DSXchange

As pointed by Ray, for full month name %mmmm should be specified.

"%mmm" will give January as Jan, September as Sep etc,.

So the code for your requirement is

One more interview question?

Please search this forum first and I think I remember an advise for you from Ray to join a training program at the earliest. Incase you weren't the one, then I sincerely would make the same advise.

priyadarshikunal wrote:you should not do that as this will invalidate all the entries in XMETA.

Hi Priyadarshi,

I don't think so that if we delete the Table Definitions at the Project level, the entire XMETA will be affected.

Correct me if I am wrong.

My question is do we need to give the full path of the project after domain name ''hipwd02.bentley.com" or if I give project name is that going to work with out a full project path . Any help is greatly appreciated. Ideally the full project path name should be given. (Atleast in AIX that is th...

Login to the server either as "root" or as "dsadm" user. Locate the folder in the Server where these Table Definitions are stored and delete them. If still you are unable to delete from the O/S level, then try to rename the folder by adding ".old" and create a new folde...

Hi Srinivas,

In the source data "Empno" means Employee Number as per my guess and normally Empno is unique identifier of the Employee and "Ename" would be same for a "Empno".

List down your requirements one by one and then a job design can be worked out.

dsfellow wrote:We have already tried to change the read only flag within the dsx-file and import them again into project B. No success.

Is it not getting imported the second time? Or was the import successful but the problem is still persisting?

It is simple Tony drawtime between 00.01 to 11.59 is AM and 12.00 to 24.00 is PM Not that simple I guess Venugopal. In 12 hour format without the AM/PM mentioned as it is the case with the source data example provided by Harikumar, 4:00 can be either morning or evening. And one more thing is that 1...

harikumar wrote:i have source like
balance,drawtime
20000, 8.30
50000,10.20
3000,4.00

In this data, how do you differentiate between AM & PM?

Without that information the conversion would not be possible.

A key Column is "Nullable" in DB2 Table.

Hi Mark, The following are the few methods to track user activity at the AIX O/S level. You can specify in the user's .history file in the /etc/profile with a few lines like these: HISTSIZE=10000 mkdir -p $HOME/.history HISTFILE=$HOME/.history/.history.$(date +%Y%m%d.%H%M%S).$$ This would keep 10,00...

ds_dwh wrote: I NEED IN PARALLEL JOBS

Why not Server Jobs?

And as Craig pointed out, post the calculation logic and sample values.

Only then anybody can help.

If it is NFS drives you are using, then changing the location won't create any problem I guess.

Create a link in AIX for your destination folder and map "XmlFiles" folder to it.

Thanks Craig. I'll speak to the support provider and once the fix pack is installed, I'll test the DB2 again.

Is the job getting aborted because of this?

I've seen this message in few of my jobs but the jobs will run fine despite this message.