Get answers.  Share knowledge.  Collaborate with peers.




Suppress/trailing blanks in a string variable through CLLE
Is there possibilities to suppress leading and trailing blanks in a string variable through CLLE??

Answer Question   |  March 19, 2012  12:34 PM
AS/400, AS400 RPGLE, CLLE
asked by:
275 pts.

DNS Name server IPV6
Hi, I have two questions 1)Can the same dns server resolve the same dns entry for an IPv4 nad ipv6 address 2)i have a ns record for “www” which points to an ipv4 address. Now if i create a quad a record i.e(AAAA)for an ipv6 address, it gets created without an error but i can’t [...]

Answer Question   |  February 27, 2012  12:29 PM
DNS, DNS Records, IPv6, IPv6 on Windows networks
asked by:
125 pts.

access 2003 mdb file size increases automatically
please if you can tell me why size of an access 2003 file automatically increase whereas no data is entered or very less data. it increases upto more than 1 GB. once the same data is imported into another file it is of the size of about 20-30 mb. strange? i have used anti viruses [...]

Answer Question   |  February 27, 2012  9:01 AM
MDB, Microsoft Access 2003
asked by:
5 pts.

As400/CLLE issue
can we load subfile through clle?

Answer Question   |  March 17, 2012  7:45 AM
AS400 iseries, CLLE
asked by:
200 pts.

How to setup approval request for a group mail
Please let us know how to setup an approval for any email send to a domino email group send by internal notes user. This feature we were using with TrendMicro ScanMail for Domino in which we can define recipient group name and if send wants to send email to group users it will first go [...]

Answer Question   |  February 20, 2012  6:30 AM
Domino on Linux, Lotus Domino 7.0.2
asked by:
40 pts.

Oracle SaaS license
We have build an application for the Dutch soccer association running in a private cloud. We want to extend this to other sports and countries using a SaaS model. Oracle has launched a SaaS license for ISV’s. We are currently use Oracle SE. Which Oracle license do we need for the (external users) SaaS environment. [...]

Answer Question   |  February 27, 2012  10:17 PM
Oracle Database Versions, Oracle SaaS license
asked by:
5 pts.

Able to ping L3 VPN but unable to tracepath
I am running an L3 VPN between 2 edge routers and have connected one router to a client (Linux Host). I tried pinging from the client an IP address (present on the other router) that was learnt via BGP VPN. It’s pinging, but I am unable to do tracepath from the client. It gives me [...]

Answer Question   |  March 2, 2012  8:07 PM
BGP, L3 VPN, Linux hosting
290 pts.

Win a free Microsoft SQL Server 2012 Pocket Consultant book
Enter for your chance to win a brand new 2012 Microsoft SQL Server Pocket Consultant book by William R. Stanek.  To win, answer below: What would you like to learn or improve about your SQL server skills over the next year?  Good Luck!

Answer Question   |  February 27, 2012  7:00 PM
SQL
asked by:
11,410 pts.

Digital certificate licence renewal in AS/400
Please help me on How to install or update DIGITAL CERTIFICATE LICENCE in AS/400. Kindly provide me the steps for this….!

Answer Question   |  March 19, 2012  4:22 PM
AS/400, AS/400 administration, AS/400 installation
asked by:
275 pts.

Problem – Outlook 2010 calendar invites with attachments not working – google apps/gmail
Hi there, Has anyone found a solution to this problem? We have just changed to Outlook 2010 and also migrated to Google Apps for business and are having an issue with Outlook 2010 calendar invites with attachments. This is a problem that is happening when we send Calendar invites from Outlook 2010 with attachments – [...]

Answer Question   |  May 7, 2013  3:19 PM
Google Apps, Microsoft Outlook 2010, Microsoft Outlook Calendar
asked by:
35 pts.

max query expression
have a very basic table: dwg, dwg rev, rev date – what query expression do I write to show only highest rev?

Answer Question   |  February 27, 2012  2:51 PM
Microsoft Access 2003, Microsoft Access queries
asked by:
5 pts.

Migration from exchange 2003 AD to new exchange 2010 AD
Current Environment is: Old domain ([strong]domain A[/strong]) two domain controllers, 1 Exchange 2003 sp2 server with about 90 users on. New Domain is Parent domain ([strong]domain Z[/strong]) with exchange 2010 setup (HUB and CAS on one server, Mailbox on another server). Then two child domains where the users are setup ([strong]sol.domain.Z[/strong]) with trust setup when [...]

Answer Question   |  February 27, 2012  12:32 PM
Exchange 2003, Exchange 2010, Exchange migration
asked by:
5 pts.

AS/400 LAN printer problem
Hi,  Two OUTQs in two systems has been assigned to the same lan printer.ie both systems have a device and OUTQ created with the same IP address. but out of two, the one which is starting first is taking the control and the print from the other printer is going to PND status.  Both Printers [...]

Answer Question   |  February 27, 2012  11:43 AM
AS400Printing, LAN Printers
asked by:
5 pts.

RUNSQLSTM ALTER TABLE
i’m trying to run SQl statment in batch job to alter Table CCSID to 420 but i have error Reason code 10  Hani 

Answer Question   |  February 27, 2012  10:51 AM
AS/400 V5R3M0, SQL tables, SQL/400
asked by:
120 pts.

Calling stored procedure in a database to query data in another database
Hello, I am writing a stored procedure that will query data from another database, but the database name is variable. Do I have to use a dynamic query? We dont want to use dynamic queries because of performance loss. But is there a way to do it without a dynamic query? Example GetData ‘some_remote_db_name’; and [...]

Answer Question   |  February 27, 2012  10:25 AM
SQL Database, SQL Server 2005
asked by:
15 pts.

OPNQRYF in CL
HI I need to filter the records for the particular date range from a file and i need to store it in a temp file.File has date field with length 7,0 centurion date format… Can anyone post the code

Answer Question   |  March 17, 2012  9:09 AM
AS/400, CL/400, OPNQRYF
asked by:
510 pts.

As400/CLLE issue
i made a PGM for read as well as write the record in DSPF but my PGM doesn`t read that PF it not showing any error .. it shows Blank value in varible. PGM                                           [...]

Answer Question   |  March 17, 2012  7:18 AM
as/400 data, CLLE, PGM
asked by:
200 pts.

SAP Portal & GUI Printer setup
Hello,  I want to setup Printer in the SAP in both GUI & Portal so that user can directly print from SAP only in the excel or any document format

Answer Question   |  February 27, 2012  7:06 AM
SAP, SAP GUI, SAP portal
asked by:
5 pts.

Comparing improvement in software response time with its previous version.
Hi, I have a question, which looks silly but I am getting different opinion among our stake holders.  I need to report an improved performance in our new version of software, where the total time required for for a functionality, say ‘Login’ in new version takes 2 seconds where as it takes 4 seconds in [...]

Answer Question   |  February 27, 2012  6:59 AM
Performance Measurement, Software response time
asked by:
5 pts.

Lotus Notes Printing Issue
For some clients, their Lotus Notes can’t print email properly where the print output is like html script. Coul you help me to solve this problem? Thanks in advance, Azhyev

Answer Question   |  March 9, 2012  4:42 AM
Lotus Notes 8.5.1, Lotus Notes printing
asked by:
115 pts.