DSXchange

Hi,

Make sure all the jobs under the Job Sequence should be compiled.

Hi Arnd,

I would suggest that you manually enter a fixed-format text that you can parse out of the text, such as "Job Created on yyyy-mm-dd" to store that information.

Do u mean that we should maintain the text files manually?
thanks in advance.

Thanks Arnd n Kumar, Arnd wrote If you need to do this you will have to put your own version and date information into a text field such as the long job description, which is best suited for this. Usually we maintain Version control tool for maintaining the job modifications. Other than version cont...

Hi SELECT INSTANCE,CREATOR,DTC FROM DS_AUDIT WHERE CLASS ='2' AND INSTANCE = 'gmt1'; This is working fine. And I have one more doubt regarding this. Suppose I created one job on Feb 2nd in Dev env and moved that job to Producton on 6th Feb. Now If give the above query in Productin admin which date w...

Hi,
I tried this query at command line but not working. and I searched in the forum also but I couldn't get proper information. Can anybody help me?

thanks in advance.

Hi ,

I want to see the job creation date. How can I see it? Is there any command for that? Plz help me.

Any help can be appreciated.
thanks in advance

HI ,

I have installed DS7.5 n Db2 in my pc. but i am not ablt connect to db2 database thru DB2/UDB stage. Is there configuration set up to be done. If so please let me know how to do that.

thanks in advance.

Hi, I am loading the data from file to DB2UDB. When I run the job I am getting a Warning message. Warning msg1: LoadZFTGLALLOCATETbl..XfmTrimAndDateConversion: [IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005 Warning msg2: LoadZFTGLALLOCATETbl..XfmTrimAndDateConversion: [IBM][CLI Drive...

Hi Kumar,

use sort to capture the change in the key, and a transformer to collect the duplicates.

Can u explain the quoted one indetail plz?

Hi,

How to implement the Incremental Aggregation Loading in Server Jobs?

Any assistance can be appreciated.
thanks in advance

Arnd,

Ereplace(Space(10-Len(Trim(ColName)))," ","0",-1,1) : Trim(ColName)

Could you explain the function which is mentioned above plz?

thnaks in advance

Sorry for all I am not getting the output when use the function which u suggested in the Key Expressin of Hash file(in XFM). But I am getting the required output by using the following function. Ereplace(Space(10-Len(Trim(ColName)))," ","0",-1,1) : Trim(ColName) Why I am not able...

Hi ArndW

FMT(In.ColumnName,'6"0"R') .

What is 'In' in the function? what does it represent?

Your assistance can be appreciated

Thanks for your suggestions.

I will try n come back.
One doubt: Can I use EReplace Function to eliminate the leading zeros?

thnks in advance

Hi Kumar, This function is not working properly and its giving empty values(no values in the field) Use Conver(Column,'0','') -Kumar The remaining functions which suggested by Arnd working fine. And my other doubt is the ColA which is having leading zeros is my Hash file. I need to match with it wit...