Author |
Message |
Topic: Get QMF procs and queries a usual file |
Anta
Replies: 8
Views: 8731
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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.
... |
|