select gthamcode as hamcode, gtnumber as item, ‘G’ from testlib/gtinl01 where (gtnumber between 08000000000000 and 08999999999999) union all select modkey as hamcode, modndcnum as item, ‘M’ from testlib/hammodel where (modndcnum between 08000000000 and 08999999999) This works with interactive SQL but I need to use this in an COBOL embbeded SQL cursor. The ’M’ and ’G’ are constants [...]
Answer Question | February 28, 2013 7:23 PM
AS/400, SQL Cursors
I’m sending a file from Sterling Filegateway to Direct:Connect. It fails. FG lists that a mandatory parameter is missing. The C:D stats show error codes of LCOT000I, LCOA007I and LIPT027I. What do I need to do to fix this?
Answer Question | February 28, 2013 5:57 PM
Why can’t I open my EXE files….says I need an association
Answer Question | February 28, 2013 4:36 PM
.EXE file, Windows Vista
Recent surveys show that 65% of large and enterprise-sized businesses are now using multiple hypervisors, and even medium and small companies are joining in. For those using hypervisors, are you considering enabling additional hypervisors?
Answer Question | March 11, 2013 3:29 PM
How can be search external program (outside Synon) which is calling print file function (PRTFIL). Actually, I know to search all function which are calling print file by the option 91 or take U at subfile selector or 95 at object usage screen but that approach can only work to identify internal function. Do you [...]
Answer Question | February 28, 2013 12:36 PM
AS/400 Synon, Synon
I am new to servlets. I installed my Tomcat server in C: drive. Is it possible to store all my servlets related files like .class file web.XML file in G: drive and make work the program. Instead of saving the files in tom container folder?
Answer Question | February 28, 2013 11:55 AM
How can I move data from XML to Data structure if data is more than 9999 in XML? The problem is I can declare the data structure with array max size 9999 where as using XML-INTO (ex: XML-INTO OrderList %XML(‘/home/orderlist.xml’) : ‘ doc=file case=any’) ). I can load first 9999 set of data but then [...]
Answer Question | February 28, 2013 9:53 AM
AS/400, RPGLE, XML
If SAN to SAN hardware level replication solution is implemented, how can we utilize this solution to transfer MSSQL 2008 R2 databases’ MDF and LDF files.
Answer Question | February 28, 2013 9:26 AM
MSSQL, MSSQL 2008, SAN
Dear Expert, Everything was working fine for me. One bad day I have removed my GM email account and created new email account after 2 days. The problem I’m facing is the user sending mail from cache mode can’t send him email. User send email from web Outlook have no problem. What I think in [...]
Answer Question | February 28, 2013 6:12 AM
Microsoft Exchange 2010, OAB
Can I own a domain name indefinitely?
Answer Question | February 28, 2013 10:33 PM
DNS, domain names
What command would I use to create a physical file?
Answer Question | February 28, 2013 9:36 PM
AS/400, Physical File
I copied my names.nsf from a 8.5.3 client to a 8.5.2 client and got a ‘RRV bucket is corrupt’ error. Unfortunately, I did not backup the 8.5.2 names.nsf first. How do I create a fresh names.nsf file so I can export and import my contacts? I am not sure why my company wants me to [...]
Answer Question | February 27, 2013 6:09 PM
Lotus Notes 8.5, Lotus Notes error messages, Lotus Notes migration
A buzz is stirring through enterprises as they decide whether to use social media analytics. While it provides a lower-cost alternative with instantaneous feedback on different data services, many businesses are wondering if this is the right time to jump on the bandwagon. Does your company invest in social media analytics? If so, has it [...]
Answer Question | March 11, 2013 3:46 PM
Analytics, social media
Hi, I am having problems printing from AS/400 running v5r4 to a Canon iR3235. Prints seem to be coming off out of order. But only happening half way through each batch of around 100 prints. The first half is fine, but then all comes off wrong. IBM have recommended setting up printer over LPR and using [...]
Answer Question | February 27, 2013 3:36 PM
How do I get the user input, so I can use it on my query on Oracle Reports Builder 6? The report will be executed on a client desktop. Im using autosearch, and just found this : Report.GetAutoSearchDescriptionLines(Memo1.Lines);which get me the whole search description, including the user input for the search criteria. Is there any [...]
Answer Question | March 1, 2013 1:45 PM
Oracle Reports 6i, Oracle Reports Builder, SQL Query
I have 1TB external HDD. I want to know if it is possible to install any antivirus in my external hard drive because I might plug it in another computer that doesn’t have an update and that has a virus. Which one is good antivirus for external hard drive?
Answer Question | February 27, 2013 1:14 PM
Antivirus, HDD, Security
Are AMD processors as good as Intel processors?
Answer Question | February 27, 2013 1:11 PM
AMD processors, Intel Processors
When I create a new message, the lines in the To, CC & BCC are missing.
Answer Question | February 27, 2013 8:03 AM
Lotus Notes 8.5, Lotus Notes administration
Hi ! How can I block the users for the use of Operational Assistance Menu(Esc Key)?
Answer Question | February 27, 2013 6:03 AM
AS/400, AS/400 Menus
Could any one let me know what is the use of this EVAL-CORR opcode with a sample program
Answer Question | February 27, 2013 4:27 AM