SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 The Yak Corral
 Twit List
 New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 88

X002548
Not Just a Number

15586 Posts

Posted - 04/10/2008 :  12:38:49  Show Profile  Reply with Quote
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



Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 04/10/2008 :  14:20:39  Show Profile  Reply with Quote
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
Go to Top of Page

elancaster
A very urgent SQL Yakette

United Kingdom
1208 Posts

Posted - 04/11/2008 :  04:05:51  Show Profile  Reply with Quote
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
Go to Top of Page

elancaster
A very urgent SQL Yakette

United Kingdom
1208 Posts

Posted - 04/11/2008 :  06:52:59  Show Profile  Reply with Quote
thank you for not answering my question...?

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=100541

...think i'm just in a bad mood today

Em
Go to Top of Page

elancaster
A very urgent SQL Yakette

United Kingdom
1208 Posts

Posted - 04/11/2008 :  07:25:03  Show Profile  Reply with Quote
right, i give up! i'm going to the pub

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=100774

Em
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30282 Posts

Posted - 04/11/2008 :  16:23:41  Show Profile  Visit SwePeso's Homepage  Reply with Quote
I have a feeling this http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=100811 will end with
"I am sorry. I posted the wrong query".



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30282 Posts

Posted - 04/11/2008 :  17:02:49  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30282 Posts

Posted - 04/14/2008 :  05:37:34  Show Profile  Visit SwePeso's Homepage  Reply with Quote
This is why some people should learn "Do you want fries with that?"...



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 04/14/2008 :  07:19:47  Show Profile  Reply with Quote
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.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30282 Posts

Posted - 04/14/2008 :  07:31:11  Show Profile  Visit SwePeso's Homepage  Reply with Quote
I have an obligation due to my nick...



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 04/14/2008 :  11:14:42  Show Profile  Reply with Quote
So, you've been suckered in.

Large or small fries with that?
Go to Top of Page

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 04/14/2008 :  13:04:35  Show Profile  Visit nr's Homepage  Reply with Quote
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_23319317.html

==========================================
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.
Go to Top of Page

tosscrosby
Aged Yak Warrior

USA
676 Posts

Posted - 04/14/2008 :  13:12:31  Show Profile  Reply with Quote
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
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 04/14/2008 :  13:16:00  Show Profile  Visit spirit1's Homepage  Reply with Quote
nigel!!! you participate in ExpertSexChange???? by golly!!

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 04/15/2008 :  07:13:28  Show Profile  Reply with Quote
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=100991

Oh my! Should know better as well.
Go to Top of Page

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 04/15/2008 :  12:44:00  Show Profile  Visit nr's Homepage  Reply with Quote
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.
Go to Top of Page

tosscrosby
Aged Yak Warrior

USA
676 Posts

Posted - 04/15/2008 :  13:36:59  Show Profile  Reply with Quote
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
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30282 Posts

Posted - 04/15/2008 :  15:23:27  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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"
Go to Top of Page

cat_jesus
Aged Yak Warrior

547 Posts

Posted - 04/15/2008 :  15:31:37  Show Profile  Reply with Quote
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!
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 04/15/2008 :  17:11:22  Show Profile  Reply with Quote
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
Go to Top of Page
Page: of 88 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000