Converting from RPGLE to DB2/400 SQL
The starting place should the Information Center topic on <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/sqlp/rbafyroutines.htm”>Database Routines</a>. The Related Information topic under Database lists numerous other resources. One listed resource that you might find particularly useful is the <a href=”http://www.redbooks.ibm.com/abstracts/sg246503.html?Open”>Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database for iSeries</a> Redbook. And, of course, the actual SQL Reference manuals [...]

View Answer   |  June 22, 2010  12:56 AM
DB2/400, RPGLE, SQL, SQL migration

How to commnicate with a PDA built-in scanner using vb.net smart device?
hi did u get the solution ?? i am looking for the same solution pls. let me know if u got it. thankx

View Answer   |  June 19, 2010  11:04 AM
Framework 3.5, PDA barcode scanner, Smart Device, VB.NET, VB.NET 2008, Windows CE 5

What should be done first: code reviews or unit tests?
I would recommend doing the Code Review before unit testing. Why? Because for junior/new members of a team, you can catch common coding practice errors, share recommended styles, and in general make sure that what the developer is going to test (and presumably fix as necessary) is aligned with the requirements and your business practices [...]

View Answer   |  June 18, 2010  9:39 PM
Debugging, Developer, Development, Functional testing

How to send SMS messages via ASP.NET using laptop’s tethered modem
ha ha ha

View Answer   |  June 18, 2010  11:52 AM
ASP.NET, Mobile messaging, Short Message Service, SMS Messages

Why doesn’t the substring of a large field in CLLE program work correctly?
<i>Why does this not work correctly…</i> There’s no way for us to know because you don’t show us the code that fails. Most likely it’s because the coding is incorrect. My first guess would be that one or more variables is DCLed incorrectly. My second guess would be that the parms are sent incorrectly. Tom

View Answer   |  June 18, 2010  12:42 AM
CLLE, CPF errors, Substring

Renames clause in cobol
Depending on which COBOL you are using, if you only use the field name it may default to the first one defined. However, virtually all flavors of COBOL support a qualification of COBOL field names and you probably want to use that syntax.. 01 IN-REC. 05 FIELDA PIC X. 05 FIELDB PIC X. 01 WORK. [...]

View Answer   |  June 17, 2010  8:44 PM
COBOL, COBOL statements, Programming Languages, RENAME statement

RSS Feed Functionality in SharePoint 2010
All SharePoint (2007/2010) lists and libraries are RSS enabled. They also support email alerts. Be careful of terminology as you search for information–the word ‘alerts’ will get you going in the wrong direction. In any event, you can use the RSS viewer web part to look at any SP or external RSS feed. <i>This question [...]

View Answer   |  June 17, 2010  7:46 PM
RSS feed, Sharepoint 2010, SharePoint 2010 functionalities

In SharePoint 2010, what is Language Integrated Query (LINQ)?
LINQ is an extension to the .NET framework which adds native data querying capabilities to .NET code. It is frequently used by developers to provide strongly typed queries using “Lambda” expressions. SharePoint 2010 includes LINQ support to insulate developers from having to understand the underlying data schema (CAML) Got PowerShell? Windows PowerShell is now the [...]

View Answer   |  June 17, 2010  7:33 PM
Language Integrated Query, LINQ, Sharepoint 2010, sharepoint 2010 features

Programming language for website development
type? scripting language – good choice I suggest you to visit <a href=”http://phpforms.net/tutorial/tutorial.html”>php tutorial</a>

View Answer   |  June 17, 2010  7:21 PM
Programmers, Programming Languages, Web development

SQL Query for Price Data of Different Stocks from 1 table with same dates
I’m not sure I understand correctly, but you could try something similar to this: <pre>SELECT s1.date,s1.stock,s2.stock,s1.price,s2.price FROM your_table s1 JOIN your_table s2 ON s1.date = s2.date AND s1.stock != s2.stock WHERE s1.stock = <something> AND s2.stock = <something> AND s1.date BETWEEN <something> AND <something>;</pre>

View Answer   |  June 17, 2010  5:10 PM
SQL Express, SQL Express 2005, SQL Query, SQL Server

procedure create with compilation error ora-6550
You are missing the ‘IS’ (or ‘AS’) keyword: <pre>create or replace procedure p1 (a in number,b in number) <b>is</b> begin insert into staff(fno,lno) values(a,b); end p1;</pre>

View Answer   |  June 17, 2010  4:30 PM
CREATE TABLE statement, ora-6550, Oracle error messages, Syntax errors

How to recover a PDS member
You are correct about it being a logical delete until the next compress. At the front of the PDS is the PDS directory. This is where the logical delete takes place. One can (or at least used to be able to ) process the directory as a sequential dataset. But I haven’t done this in [...]

View Answer   |  June 16, 2010  3:01 PM
Dataset, Mainframe Datasets, Partitioned Data Sets (PDS), PDS, z/OS

SQL Server table structure
Yes. If you are using SQL 2000 or older then query the INFORMATION_SCHEMA.tables and INFORMATION_SCHEMA.columns system views. If you are using SQL 2005 or newer then query the sys.tables and sys.columns catalog views.

View Answer   |  June 16, 2010  12:25 AM
SQL commands, SQL Server, SQL Server tables

Reduce the response time when querying the database
Correctly setup the indexes to improve performance.

View Answer   |  June 16, 2010  12:23 AM
Database query, Java, Storage in 2010

I’M UNABLE TO COMPILE RPGLE SOURCE
If this is an existing program that was compiled on your system, then somewhere there is a source member named CMQGMOG If it is not compiling for you, then whatever library that files resides in is not in your library list. I would do WRKF *ALL/QCPYSRC and then use PDM or Ops Nav to look [...]

View Answer   |  June 15, 2010  8:30 PM
AS/400, RPGLE, Source code

Compare Two Tables With Identical Fields
Something like this should do the trick: <pre> —* FIND THE ROWS IN TABLE TTESTA THAT HAVE NO MATCH IN TTESTB —* SELECT COL1, COL2 FROM TTESTA TA WHERE NOT EXISTS (SELECT 1 FROM TTESTB TB WHERE TA.COL1 = TB.COL1 AND TA.COL2 = TB.COL2) ; </pre> An outer join could also be used. If you [...]

View Answer   |  June 15, 2010  2:12 PM
SQL, SQL tables

Rational Functional Tester with Terminal Extension
Check your key mappings, and make sure they are pointing to the correct keys.

View Answer   |  June 15, 2010  3:45 AM
RFT, Software testing, Terminal Extension

Outlook 2003 error message: MAPI catastrophic failure
There are several places you can start. Are you running in cached mode? Try taking it off cached mode. Try starting in safe mode by closing outlook, holding down your left shift key and starting Outlook. If it starts fine in safe mode you will want to troubleshoot add-ons. If it still does not start [...]

View Answer   |  June 14, 2010  9:01 PM
CLR, MAPI, Outlook 2003, Outlook 2003 error messages, Outlook error messages

SQL Query for Time Filed
Try this <pre>select * from table where DATEPART(ss, trade_time)%5 = 0</pre>

View Answer   |  June 14, 2010  5:32 PM
SQL Query, SQL Server 2005, SQL tables

Change spool file status from RDY to SAV by API
I’m not aware of any API nor command that will set a SAV status. Nor would I expect one because it effectively causes the system to lie to the users. A status of SAV means that the spooled file has been processed by a writer and then kept after printing completed. If you force the [...]

View Answer   |  June 11, 2010  8:31 PM
API, AS/400, AS/400 API, Spool files