DSXchange

Hi, Ineed a help from experts .I have requirement like this . This interface will be based on XML messages sent over MQ. FEMS is going to send a request to update factors in OIM. Message received by OIM will trigger a process that will load factors into WWPRT database, recalculate BRL prices and for...

Hi,

It's a server job .Its a DB2/UDB stage. Which option I have to select in this four option to make distinct work


Enter Custom SQL statement

Use SQL Builder tool

LOad SQL from a file at run time

Generate SELECT clause from column list;enter other clauses




Thanks,
somu

Hi, Iam new to datastage. Iam having a problem with db2/udb enterprise stage . I have sql statement like this for lookup Select MANDT,EE,VARCOND,SWO......From.... WHERE ..... . I want to modify the Sql statement by adding distinct. When Iam Trying to add this distinct in output page .... general tab...

Hi Arnv, I have a job that is having sort stage. The problem is it will sort only on that file. For example If iam having same material in first file and also the same material in the 10 th file will this sort stage sort on all files or it will sort columms in first file first then second and so on ...

Hi, I Want to split my source file in to smaller input files. I have material data in that. If I split my source files in to smaller ones then I may face duplicate materials in different files. So how to sort the file on different fields in a file first so that I can split the sorted file in to smal...

Hi,

My problem is db2 ,Ascential datastage are on different servers . wether I have to give the path of my DB2 installation directory for DB2instance in Administrator APT_DB2INSTANCE_HOME or can I give a server name directly
in outputs page --- properties ---connection/server.


Thanks

Hi, I can give you more information about my problem . it says TUTL 000031 09:24:25(001) <main_program> The open files limit is 12000; raising to 2147483647. ##I TOSH 000002 09:24:25(002) <main_program> orchgeneral: loaded ##I TOSH 000002 09:24:25(003) <main_program> orchsort: loaded ##I TOSH 000002...

Hi , Iam having a problem with db2 lookup. In db2 stage -- output page --- properties tab --- connections ---- use default server option i gave as true. Iam getting an error like this ERROR EXECUTING VIEW DATA COMMAND: ## E TNDB 000000 13:59:53 (001)<DB2_UDB_Enterprise_1> Error ldx=1; how to set DB2...

Hi Kumar,

Happy NewYear. I tried different options in format - record level - final delimiter= whitespace and in field defaults i gave delimiter = none and quote = single. I got my data .

Thanks guys for your help . Thanks kumar

Hi Roy,

Happy NewYear. Thanks for your reply.I have gone through the documentation and I also tried by making all columns
as Varchar but Iam getting the same problem.

HI Guys, I am trying to run a job with multiple instances. I selected the option "Allow Multiple Instance" in Job properties and parameterized my source files. Whats the procedure now to run with multiple instances? After I run my job with file 1 as source I am trying to run it again but i...

Hi, Iam new to this datastage . Iam having jobs in server and some jobs are running slowly. I want to develop those jobs in px. When Iam trying to read a data from sequential stage in px iam getting an error which says Error Executing View data command ## E TOIX 15:53:21 (003) <seq_file 18> unable t...

hi , I am doing a range lookup on a UniVerse stage . my lookup file is a flat file which I preloaded into a hashed file. Now I am giving this source file to the UV stage. When I look in the data browser of UV stage the data it shows is not exactly the data in the hashed file. It followed a pattern w...

hey ml,

what should I be loading into hashed file ? low_num,high_num & group..what is id_num ?

-somu

Hi Guys, I believe lot of people have faced this problem. I have source in flat file. I need to lookup to a flat file which has ranges . eg: source column, number Lookup file, low_num,high_num, groupid I have to lookup to this file and if my source number falls in one of the groups I need to get the...