DSXchange

Have you tried to and, if so, with what result? What does the manual or on-line help suggest? ... Ray, It did'nt allow to do so, I belive it is possible to us multiple close statements when we use DB2 Enterprise Edition, and there has been no reference abt how many close statements can be used in t...

Hi All,

I would like to know if we can use multiple close statements, where we run muliple select statement per close statement in the Oracle Enterprise Edition Stage.

regards,
varsha

Hi All, A particular customer is getting following error, when he tries to view data from a DB2 Enterprise Edtion Stage, the Db2 db is present on a remote machine. The Db2 client is installed on the machine where datastage server is installed. They are able to successfully import the metadata from D...

What is your job design, I'm guessing just the two Oracle stages? :? If so, you'll need something between them to map the columns. For example, to map 'a' to 'd' (etc) in your second example. Do u mean that we need to give an alias for column a as d using a transformer and then map it to the so tha...

Hi, There is a particular problem which we have encountered. When we try to load data from Oracle Table A(Using Oracle Enterprise Stage) To Oracle Table B(Oracle Enterprise Stage) Using the Write Method= Load, When the column names in both the tables are same then there is no error say Table A Table...

Try Convert('%3D',':',Input.String). that should work to replace your first string. Use stage variables and convert once for the %3D value and again for the next value. You might try nesting the function, but I like using stage variables instead makes it easier to read later. Let me know if this wo...

Hi, I need to do the following in datastage input string lmundada%3Dabc%3Dlmno%2D I need to replace all '%3D' with ':' and all %2D with ',' output string lmundada:abc:lmno, I used convert function but convert function converts all occurances of % to :. I need to do something similar to replace funct...

Hi, What I am trying to do is the equivalent of select event_session_id, first(ref_qry_strng_text), first(agent), first(page_id), first(start_dt_tm), last(start_dt_tm), first(timediff), web_site_id, first(clnt_ipa_num), sum(page_cnt), first(link_key), sum(tot_file_size_num), last(nav_path) from sess...

The job I have developed using transformer and remove duplicates stage has a strange behavior, the aggregated values are obtained if I take fewer records, but when I run the job for bulk of records, the result obtained is not accurate. I have not used any partitioning or parallelism in the jobs. And...

info_ds wrote:hi varsha,

date format as u have mentioned

d1=28/Aug/2005:17:00:07

i tried like this.
DateToString(StringToDate(Left(d1,11),"%dd/%mmm/%yyyy"),"%yyyy-%mm-%dd") : " " : Right(d1,8)

it works fine.

Thankz for the input, the code works.

regards,
varsha

Hi,

I have input value for date as follows

28/Aug/2005:17:00:07

I need to obtain the following string

2005-08-28 17:00:07

I have used many stage variables to get the above value.
what is the best way to get the above mentioned value.

regards,
varsha

Explain WHY you have this doubt. Have you run the job? Does it work? Do your Lookup stages have reject capturing or do your jobs have downstream null handling on the looked-up column(s), so you can determine whether the lookups failed? The job works fine, I am in the process of running the job with...

Thankz for the help, and for all those who replied, I am able to run the multiple instances of the job.
I have a doubt if my jobs are using lookups and if I run the jobs as multiple instances and in parallel, is there a possiblilty of the lookups failing.

Hi, I am in the process of using a change capture stage as a replacement for checking if data being processed every day if it is present in the database, if it is present then we update a set of fields, otherwise we need to insert the data. But I have 2 categories of updates for which I need the val...

With respect to the performance does the change capture stage provide better performance when compared to the lookup stage.