Search results for query: *

I am working on a project that would allow our application to more efficiently search through instances(rows on a table). This is current process: Var ptr is pointer to MessageRefQry Var ptrs is list of pointer to MessageRefQry ptrs = LIST(currentclass,LIST_ALL) FOR ptrs,ptr IF iMsgNum =...

rstitzel I am glad I could help. Thank you for my first star.

I have never tried this so I don't know if it will work but it appears that you can use a Date statement in the select statement. I got this off of code400.com SQLRPGLE - Some date processing with SQL SQL Date Support This query produces these results: Order No. Ship Date 1...

Thank you Mercury2 for all your help. I am close to being done with my first conversion and it has been quite an experience to say the least.[hammer]

So create an array to extract the first name, middle initial, etc? Just making sure I understand.

I don't think I am understanding the substring function. I want to place the first name, middle initial, last name, and designation in a separate bucket. Your code helped me place the first name in a buckets. I tried to use your example to place the middle initial in other bucket. BegSr...

Thanks Mercury2! I am very new at this and appreciate your help. It work perfect.

I decided to tackle the task of converting a COBOL pgm to RPG IV (Free format). I am trying to break unstrung variable into strung variables. For example: 'Susan E Gantner MD' is being returned as 'Susan E Gantner'. I just want 'Susan'. BegSr UnstringPrvdr...