MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 8 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Get QMF procs and queries a usual file
Anta

Replies: 8
Views: 8731

PostForum: Database   Posted: Sun Apr 06, 2008 11:41 pm   Subject: Get QMF procs and queries a usual file
Kolusu,
thank you a lot!

I have completely forgotten about the existence of the Q-tbl which contains the list of QMF-queries.

With thanks,
Anta
  Topic: Get QMF procs and queries a usual file
Anta

Replies: 8
Views: 8731

PostForum: Database   Posted: Fri Apr 04, 2008 6:18 am   Subject: Get QMF procs and queries a usual file
Dear friends;

can you please help me with one simple problem? It is not simple for me, to my regret.
There are a lot of QMF procs and queries in some data base.
Does some "one-step" wa ...
  Topic: select question
Anta

Replies: 2
Views: 1835

PostForum: Database   Posted: Fri Jan 26, 2007 3:16 am   Subject: select question
Kolusu,

thank you a lot!
It really helped.
You saved me again.

Thank you once more.

With kind regards,
Anta
  Topic: select question
Anta

Replies: 2
Views: 1835

PostForum: Database   Posted: Thu Jan 25, 2007 9:22 am   Subject: select question
Hi, all.

Sorry for bothering you with a simple question but it really confused me.
Can you please help me with it?
I have some table, one of this table's columns contains some set of values.
I n ...
  Topic: how to remove the leading chars?
Anta

Replies: 6
Views: 2608

PostForum: Database   Posted: Thu Nov 09, 2006 3:17 am   Subject: how to remove the leading chars?
Kolusu,

thank you a lot!
It is what I need.
Thank you!

With kind regards,
Anta
  Topic: how to remove the leading chars?
Anta

Replies: 6
Views: 2608

PostForum: Database   Posted: Wed Nov 08, 2006 8:35 am   Subject: how to remove the leading chars?
Dick,

I unload the table using sql and form.
In the form this column is defined as char(16).
But even in qmf I can only remove trailing chars, not leading chars - I mean using strip function.

...
  Topic: how to remove the leading chars?
Anta

Replies: 6
Views: 2608

PostForum: Database   Posted: Wed Nov 08, 2006 6:49 am   Subject: how to remove the leading chars?
Karthik,

thank you for your reply.
No, it doesn't work for me.

If I run
select char(decimal_value)
from some.table
I receive:
0000000012.000000

When I run
select strip(char(decimal_va ...
  Topic: how to remove the leading chars?
Anta

Replies: 6
Views: 2608

PostForum: Database   Posted: Wed Nov 08, 2006 2:40 am   Subject: how to remove the leading chars?
Hi,
can some one help me please?
Maybe the question is silly and dummy, but I have stopped with it.
I need to select some values from tables without leading chars, for ex, without leading zeroes.
...
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group