tag:blogger.com,1999:blog-4783686265399505970.post1620177230548836375..comments2008-10-14T12:09:10.064-04:00Moshe Ruzinhttps://profiles.google.com/109439613832160719987noreply@blogger.comBlogger20125tag:blogger.com,1999:blog-4783686265399505970.post-24347281082776958412008-10-14T12:09:00.000-04:002008-10-14T12:09:00.000-04:00as/400 still used extensively by MOST corporations due to its stability.<BR/>Such as ACME brick. BNSF. DrHorton. Orielly Auto. and many others just in DFW area of US.<BR/>For instance JDE one world used by many fortune 100. You may even use it without knowing it since there are now many graphical UIs.Careyhttp://www.blogger.com/profile/12205626869058300645noreply@blogger.comtag:blogger.com,1999:blog-4783686265399505970.post-69616152000622948782008-09-24T16:02:00.000-04:002008-09-24T16:02:00.000-04:00AS/400 Is still used and is considered a state-of-art computer as far as business models are concerned. As of a few years ago (I'm not sure about today) IBM was offering half a million for anyone who manages to hack into one. AS/400s are widely used, #1 business computer in Europe, but in US it's not as popular. It's mostly a perception problem (like you people think they are ancient). Another problem is they seem expensive when compared to Unix or other servers, but what buyers don't realize it that this price includes a lot more so that in the long run it ends up being cheaper.<BR/><BR/>For example AS/400 comes with a compiler, database, source control and security among other things. On other computers each of these are sold separately, and users have to install and maintain each one separately as well as all the expirations and licensings.mlevinhttp://www.blogger.com/profile/01831542484906424230noreply@blogger.comtag:blogger.com,1999:blog-4783686265399505970.post-58952918089072616692008-09-24T11:05:00.000-04:002008-09-24T11:05:00.000-04:00jacob da jew,<BR/><BR/>when Russian guys talk programming to each other, it's indeed a crypted method of mafia talk. When a Russian guy talks to a Russian girl in programming, it signifies a language of looove, a hot chat.Alannoreply@blogger.comtag:blogger.com,1999:blog-4783686265399505970.post-4918393713101708522008-09-24T10:58:00.000-04:002008-09-24T10:58:00.000-04:00mlevin,<BR/><BR/>isn't AS/400 like ancient? I was telling Moshe that even though still comparatively a youngling, I did program in Pascal within VAX/VMS environment (green screen monitors) as my first college programming course (yeah, that's as close as I came to mainframes). Is AS/400 still used extensively? We have one senior AS/400 guy in our shul -Oleg - maybe you know him.Alannoreply@blogger.comtag:blogger.com,1999:blog-4783686265399505970.post-58156896346250107222008-09-23T15:54:00.000-04:002008-09-23T15:54:00.000-04:00Or maybe he's just clever enough to know how to make much more money by working slower. :)frumpunkhttp://frumpunk.wordpress.com/noreply@blogger.comtag:blogger.com,1999:blog-4783686265399505970.post-70052931020112249022008-09-15T23:01:00.000-04:002008-09-15T23:01:00.000-04:00Moshe - 1. I'm not sure if he knows or not, but it sure shows lack of analytical skill. <BR/><BR/>2. This guy has 4-5 people working under him and not one of them mentioned an alternate way.mlevinhttp://www.blogger.com/profile/01831542484906424230noreply@blogger.comtag:blogger.com,1999:blog-4783686265399505970.post-38938604478416081502008-09-15T00:59:00.000-04:002008-09-15T00:59:00.000-04:00That's messed up. Nobody bothered to check if he knows anything other than SELECT * FROM?Moshehttp://www.blogger.com/profile/01145237927656807738noreply@blogger.comtag:blogger.com,1999:blog-4783686265399505970.post-37420163288263663212008-09-14T21:39:00.000-04:002008-09-14T21:39:00.000-04:00thanks. I haven't used SQL since 2001. Forgot most of it. Except last Friday saw this idiot literally hard code each record using SQL instead of putting date ranges. He billed full day for 5 people, for something that could be done by a single programmer in half an hour.mlevinhttp://www.blogger.com/profile/01831542484906424230noreply@blogger.comtag:blogger.com,1999:blog-4783686265399505970.post-53048007914976497342008-09-14T15:02:00.000-04:002008-09-14T15:02:00.000-04:00I think SQL is just a general name. MS uses T-SQL, MySQL uses MySQL and Oracle uses PL/SQL. Not sure what you use.<BR/><BR/>One of the first difference I came across when I started doing MySQL is that in T-SQL you write SELECT TOP [rows] * FROM, while in MySQL, at the bottom of the query, you put LIMIT [starting row], [number of rows].<BR/>Each also has mostly differently named functions.Moshehttp://www.blogger.com/profile/01145237927656807738noreply@blogger.comtag:blogger.com,1999:blog-4783686265399505970.post-60455131053015225102008-09-14T14:57:00.000-04:002008-09-14T14:57:00.000-04:00Moshe - is there a difference between T-SQL and regular SQL? I mean regular, the ones that are used by VB and AS/400?mlevinhttp://www.blogger.com/profile/01831542484906424230noreply@blogger.comtag:blogger.com,1999:blog-4783686265399505970.post-46140531551081590182008-09-13T22:15:00.000-04:002008-09-13T22:15:00.000-04:00Yes and no. A lot of people don't know obscure parts of programming. My previous posts get hits every day because a lot of people don't how.Moshehttp://www.blogger.com/profile/01145237927656807738noreply@blogger.comtag:blogger.com,1999:blog-4783686265399505970.post-66815988004348232072008-09-13T22:11:00.000-04:002008-09-13T22:11:00.000-04:00i'll bet this is a just a post to get people who might not come hither to do so and click on the advs.Lion of Zionhttp://www.blogger.com/profile/10342299133387602141noreply@blogger.comtag:blogger.com,1999:blog-4783686265399505970.post-11745903575018993242008-09-12T16:25:00.000-04:002008-09-12T16:25:00.000-04:00...got everything wrong...go learn SQL...Moshehttp://www.blogger.com/profile/01145237927656807738noreply@blogger.comtag:blogger.com,1999:blog-4783686265399505970.post-28413573003883685572008-09-12T16:19:00.000-04:002008-09-12T16:19:00.000-04:00but btw, SQL does sound familiar from somewhere...<BR/><BR/>and btw, now that I'm using chrome it doesn't block the ads, so now I see ads on the right side, and a whole bunch of them offer to teach SQL, I guess because that's what the post is about.The Babysitterhttp://www.blogger.com/profile/15792110478994916775noreply@blogger.comtag:blogger.com,1999:blog-4783686265399505970.post-15375489707683585332008-09-12T16:17:00.000-04:002008-09-12T16:17:00.000-04:00I'm gonna play a fun game of looking at 2 different pictures and finding the differences. <BR/><BR/>So here goes, by SET you have to write "type" while by SELECT you don't have to. <BR/><BR/>and then with select you can also create columns from variables in a table.The Babysitterhttp://www.blogger.com/profile/15792110478994916775noreply@blogger.comtag:blogger.com,1999:blog-4783686265399505970.post-56658012746845345112008-09-12T09:21:00.000-04:002008-09-12T09:21:00.000-04:00The title and tag say SQL, I thought that was kinda self explanatory, no?Moshehttp://www.blogger.com/profile/01145237927656807738noreply@blogger.comtag:blogger.com,1999:blog-4783686265399505970.post-9122282925631438102008-09-12T08:01:00.000-04:002008-09-12T08:01:00.000-04:00I believe I've said this to you at least once before, Moshe, but I'll say it again...<BR/>Um, what?Jessicahttp://jabberwocky-jessica.tumblr.comnoreply@blogger.comtag:blogger.com,1999:blog-4783686265399505970.post-17203664282606339382008-09-12T01:28:00.000-04:002008-09-12T01:28:00.000-04:00I don't think we're supposed to , Mike.<BR/><BR/>This post is in reality some kind of secret message to the Russian Mob.<BR/><BR/>Nyet Nyet!Jacob Da Jewhttp://www.blogger.com/profile/15181930948956094882noreply@blogger.comtag:blogger.com,1999:blog-4783686265399505970.post-85718767145274030212008-09-11T23:06:00.000-04:002008-09-11T23:06:00.000-04:00I did not understand one thing. So ill repeat what jacob said<BR/>Wow!!!<BR/><BR/>Amazing!!Mikeinmidwoodhttp://www.blogger.com/profile/18076346601047947913noreply@blogger.comtag:blogger.com,1999:blog-4783686265399505970.post-35280067361176332692008-09-11T21:41:00.000-04:002008-09-11T21:41:00.000-04:00Wow!!!<BR/><BR/>Amazing!!Jacob Da Jewhttp://www.blogger.com/profile/15181930948956094882noreply@blogger.com