DSXchange

Hi chulett, thanx a lot for ur responce.. this rowcount is a field which is not generated dynemically its the value comming from the source table. my req wud be to know the value in the rowcount and generate teh expression , can we do this inthe sequence ? with custom trigger. ur responce is giving ...

hey chulett thanx a lot, this was giving me some picture abt its usage. i have an issue.. i have a file generated by a job in a sequence.(job activity).so in that file there is a field rowcount. so if the row count > 0 .ex: rowcount is 0 nothgn..if 1 or 2 ..3..then .next step is to send a mail notif...

Hi all.

we are having a custom option in the job activity/trigger in the sequence job
if anybody let me know the use of this i willl be very thank full to them.
also if they provide any documentation on this.
Thanks much in advance
rajan

hey keshav..thanks a lot.. i have used tail stage ..it worked sucessfully and one more thing is..i specifies sequential mode in transformer..so the rows were in sequence there is no need for sort for me.... thanks a lot for ur sujetion it was a timely help. kumar: hi kumar, thanks a lot for ur respo...

Hi all, my req is as below. the data comes in to the transformer as below: no. name 1 a 2 a 3 a 4 a so here i want only the last row is there any option to give like only last row to be processed in transformer or the largerst num to be extracted in the since i need the largest number ie 4 , so i ne...

hey kirti kumar, really tons of thanks to u. the link was very infomative. THE issue is am using DB2 API stage. but it gives in the doc. that DB2 enterprice stages has a option to set it upsert only then it allows a reject link. i dint find any upsert option in DB2 API stage , whats the diff between...

HI all, my target is DB2/UDB API how can i extract the rows which were rejected. i learned from help is 1.Set the Parameter Array Size property to 1. 2.Use a Transformer stage to redirect the rejected rows i had set the parameter array size to 1. but how to redirect the rows to transformation. when ...

hi, thnks for the reply, i have writen routine . which creates a .txt file. teh fileincludes the warning msg of a job. so now i want to extract only db warnings from that file. what my logic is ..if any warning has sql state i need to extract them. Actually I was referring to the file created by the...

hi kirti kumar, thanks for ur responce i already tried that .that did not worked. any how i was trying using with : as delimiter..,it is dividing the the line in to 5 diff coloumns where it finds ":", my result is to extract the last field. any how this is not the correct process but ,am d...

heyyy......jhmckeever u are worth for the treat...!!!! thanxxx a lot...its working... really a timely help from u..... thanx much once again. OK, The following works a treat for me: $ cat john.txt 1,a,111|2,b,222|3,c,333|4,d,444| Sequential File / Format tab: Record level Final Delimiter = End Recor...

Hi
i was seriously waiting for a responce,thanx a lot for ur reply
ya i tried with that already..it dint worked out.

jhmckeever wrote:Rajan,

Try specifying the "Record Delimiter" with '|'

J.

Hi frnds.. here am reading a seq. file thru seq stage which has the following format. 1,a,111|2,b,222|3,c,333|4,d,444| the pipe and the commas am generating thru routine i can change what ever i want so when i read the seq file i need to view the data as no. name code 1 a 111 2 b 222 3 c 333 4 d 444...

Hi duke, ray thanks a lot for ur quick responce. i got my routine working fine. i was generating 4 files from this routine, that gives all the details for jobs,param, stages,link info. and the problem with that loop is i had a "openseq " in that loop hence that was not working..i need to l...

Hi ray since am creating a server routine which includes BASIC i want to post in server edition forum , i got an error while compiling my routine. am using the Loop ...Repeat logic, inthat loop i have this code i have checked with out this code it compiles proper in a an another test routine, there ...

Hey Duke, first of all want to appriciate u for ur fantastic job done in the sites given below,its realy grt. and as of my requirement is in parlell editioin. what am goin to do is..to write a basic code and make it a after /before sub routine and trying to acess them in PX jobs, is my idea is corec...