| Author |
 Topic  |
|
X002548
Not Just a Number
15586 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
 Posted - 04/10/2008 : 14:20:39
|
quote:
Originally posted by X002548
Now I know this a "Sequel Server" forum, but this is just too rich if you live in the DB2 world
http://www.dbforums.com/showthread.php?t=1629212
I mean, let all code in assembler
Brett
8-)
Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Add yourself!
http://www.frappr.com/sqlteam
I am trying to imagine a possible reason for moving an existing, working system from an RDMS to VSAM.
I would really be interested in hearing any possible business, financial, or technical advantage.
The good old days:
IDENTIFICATION DIVISION.
PROGRAM-ID. MYPRGM.
AUTHOR. MVJ.
ENVIRONMENT DIVISION.
INPUT-OUTPUT SECTION.
FILE-CONTROL.
SELECT INP-VSAM ASSIGN TO VSAMIN
ORGANIZATION IS INDEXED
ACCESS IS DYNAMIC
RECORD KEY IS EMP-ID
FILE STATUS IS FS-STATUS.
DATA DIVISION.
FILE SECTION.
FD INP-VSAM.
01 FILE-LAYOUT.
05 EMP-ID PIC X(06).
05 FILLER PIC X(01).
05 EMP-NAME PIC X(10).
CODO ERGO SUM |
Edited by - Michael Valentine Jones on 04/10/2008 14:33:11 |
 |
|
|
elancaster
A very urgent SQL Yakette
United Kingdom
1208 Posts |
Posted - 04/11/2008 : 04:05:51
|
Q. how do I do it?
A. like this
Q. thanks, but how do I do it?
A. like THIS
Q. thanks, but how do I do it?
A. LIKE THIS!
Q. I guess I'll leave it then...
A. WHY? do it like THIS!!
Q. is it impossible then?
A. DO IT LIKE THIS!!!
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=100671
Em |
|
|
|
elancaster
A very urgent SQL Yakette
United Kingdom
1208 Posts |
|
|
elancaster
A very urgent SQL Yakette
United Kingdom
1208 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 04/11/2008 : 17:02:49
|
Problem solved and case closed.
It was a badly written trigger that produced the error...
E 12°55'05.25"
N 56°04'39.16" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 04/14/2008 : 05:37:34
|
This is why some people should learn "Do you want fries with that?"...
E 12°55'05.25"
N 56°04'39.16" |
|
|
|
RickD
Slow But Sure Yak Herding Master
United Kingdom
3560 Posts |
Posted - 04/14/2008 : 07:19:47
|
quote:
Originally posted by Peso
This is why some people should learn "Do you want fries with that?"...
E 12°55'05.25"
N 56°04'39.16"
But still you persist in trying to help them. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 04/14/2008 : 07:31:11
|
I have an obligation due to my nick...
E 12°55'05.25"
N 56°04'39.16" |
|
|
|
RickD
Slow But Sure Yak Herding Master
United Kingdom
3560 Posts |
Posted - 04/14/2008 : 11:14:42
|
So, you've been suckered in.
Large or small fries with that? |
|
|
|
nr
SQLTeam MVY
United Kingdom
12543 Posts |
|
|
tosscrosby
Aged Yak Warrior
USA
676 Posts |
Posted - 04/14/2008 : 13:12:31
|
I think many of us are genuinely trying to help but then that frustration creeps in and continues to grow, and the comments turn a little nastier, not mean but with a subtle hint of sacarsm (well, sometimes not so subtle!) but I think we all go as far as possible to help the OP. I think if some of these "twits" made a half-hearted effort first, organized their requests and presented them with the appearance that they had 1/2 a brain, we'd continue to help them until they acheived their desired results. But come on, simple requests for more info or did you check that, are met with such resistance or shoulder-shrugs sometimes - would you even want order fries from some of them? Just asking.....;-)
Terry |
|
|
|
spirit1
Cybernetic Yak Master
Slovenia
11741 Posts |
|
|
RickD
Slow But Sure Yak Herding Master
United Kingdom
3560 Posts |
|
|
nr
SQLTeam MVY
United Kingdom
12543 Posts |
Posted - 04/15/2008 : 12:44:00
|
quote:
Originally posted by RickD
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=100991
Oh my! Should know better as well.
Sometimes it's tempting to just answer the question that's been asked.
==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy. |
|
|
|
tosscrosby
Aged Yak Warrior
USA
676 Posts |
Posted - 04/15/2008 : 13:36:59
|
Now, now guys and gals, play nice! If some of these half-wits start losing their jobs because of us, how are we to amuse ourseleves??
Terry |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 04/15/2008 : 15:23:27
|
If those people getting fired work at a bank, I couldn't be happier.
Should I trust my money with a system they built?
E 12°55'05.25"
N 56°04'39.16" |
|
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 04/15/2008 : 15:31:37
|
quote:
Originally posted by Michael Valentine Jones
I am trying to imagine a possible reason for moving an existing, working system from an RDMS to VSAM.
You probably already know this but, the DB2 RDMS runs on VSAM files. At least it did last time I worked with it about 4 years ago.
I am we Todd Did! |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
Posted - 04/15/2008 : 17:11:22
|
quote:
Originally posted by cat_jesus
quote:
Originally posted by Michael Valentine Jones
I am trying to imagine a possible reason for moving an existing, working system from an RDMS to VSAM.
You probably already know this but, the DB2 RDMS runs on VSAM files. At least it did last time I worked with it about 4 years ago.
I am we Todd Did!
I know, since that was explictly mentioned in the thread.
However, the poster means that they are moving away from using DB2 to using VSAM record access methods.
CODO ERGO SUM |
|
|
|
Topic |
|
Twit List
