Scan a string
Hi, I am using scan function in rpgle for scan string my problem is that when i scan a string with one space like ‘Invalid Customer’ then my program not given positive result or no result
Answer Question
| May 11, 2012 11:38 AM
AS400 RPGLE, RPGLE Program
Hi, I am using scan function in rpgle for scan string my problem is that when i scan a string with one space like ‘Invalid Customer’ then my program not given positive result or no result
Answer Question
| May 11, 2012 11:38 AM
AS400 RPGLE, RPGLE Program
Journaling if I drop a table
Hi Tom, New to iSeries. If I drop and recreate a table with two additional fields, will the journalling be cleared out too? Also will the jounalling be enabled when I recreate the table? I have this brief…….. We need to have the old journal entries (relating to the current layout before the changes) [...]
Answer Question
| May 4, 2012 10:35 AM
DB2/400, iSeries AS/400
Hi Tom, New to iSeries. If I drop and recreate a table with two additional fields, will the journalling be cleared out too? Also will the jounalling be enabled when I recreate the table? I have this brief…….. We need to have the old journal entries (relating to the current layout before the changes) [...]
Answer Question
| May 4, 2012 10:35 AM
DB2/400, iSeries AS/400
Primary file
While declaring a file, In file designation If I give ‘P’ for primary file, I read it will use RPG logic cycle to read file instead of file opcodes read/chain etc. But can anyone let me know how these primary file is read? I couldnt get a clear explanation in google search. If anybody elaborate [...]
Answer Question
| May 3, 2012 8:36 AM
AS/400, RPG Logic Cycle
While declaring a file, In file designation If I give ‘P’ for primary file, I read it will use RPG logic cycle to read file instead of file opcodes read/chain etc. But can anyone let me know how these primary file is read? I couldnt get a clear explanation in google search. If anybody elaborate [...]
Answer Question
| May 3, 2012 8:36 AM
AS/400, RPG Logic Cycle
VB 6.0 Database
Hi guys, I have a question about vb 6.0 database. I used ms-access to connect the database with vb project. the component I used adodc. when I try to move the project to another computer the project will say misplacing the database it lost the pathe of the db. Is there anyone can help me [...]
Answer Question
| May 3, 2012 8:02 AM
Microsoft Access, VB 6.0
Hi guys, I have a question about vb 6.0 database. I used ms-access to connect the database with vb project. the component I used adodc. when I try to move the project to another computer the project will say misplacing the database it lost the pathe of the db. Is there anyone can help me [...]
Answer Question
| May 3, 2012 8:02 AM
Microsoft Access, VB 6.0
SQL View
How to create a SQL VIEW of the file to present packed or binary values as characters? I know we can create an sql view using CREATE VIEW library/view1 AS SELECT * FROM library/filename. But can anyone tell me how to present packed or binary values as characters using this? I used the command cast but [...]
Answer Question
| May 4, 2012 7:18 AM
AS/400, AS/400 SQL View
How to create a SQL VIEW of the file to present packed or binary values as characters? I know we can create an sql view using CREATE VIEW library/view1 AS SELECT * FROM library/filename. But can anyone tell me how to present packed or binary values as characters using this? I used the command cast but [...]
Answer Question
| May 4, 2012 7:18 AM
AS/400, AS/400 SQL View
Access 2003 SQL sub-query within query
I’m trying to extract all Person.ID eligible to sit a Level 1 study exam from our database. So I setup a query to look for members with study exam level 1 not equal to “pass” or Is Null, thinking it would give me all people who hadn’t sat or hadn’t passed level one exam. However [...]
Answer Question
| May 3, 2012 1:16 AM
Microsoft Access 2003, SQL Sub-query
I’m trying to extract all Person.ID eligible to sit a Level 1 study exam from our database. So I setup a query to look for members with study exam level 1 not equal to “pass” or Is Null, thinking it would give me all people who hadn’t sat or hadn’t passed level one exam. However [...]
Answer Question
| May 3, 2012 1:16 AM
Microsoft Access 2003, SQL Sub-query
Escaping special characters in run with administrator privileges script
Hello, reviving an old one on this forum: http://itknowledgeexchange.techtarget.com/vbscript-systems-administrator/special-characters-in-vbscript-strings/ I used this script: Here is a VB Script Vall Script that will get around the Password Prompt when “RunAs” is called… ‘Start ‘———————————————————————————– ‘ To Run other VB Scripts or even Batch Files with Admin Priviliges’ ‘———————————————————————————- Dim WshShell, objFSO suser = “YourAdminAccount@YourDomain.com“ sPass = “YourPassWord” [...]
Answer Question
| May 3, 2012 8:32 PM
VB, VB script
Hello, reviving an old one on this forum: http://itknowledgeexchange.techtarget.com/vbscript-systems-administrator/special-characters-in-vbscript-strings/ I used this script: Here is a VB Script Vall Script that will get around the Password Prompt when “RunAs” is called… ‘Start ‘———————————————————————————– ‘ To Run other VB Scripts or even Batch Files with Admin Priviliges’ ‘———————————————————————————- Dim WshShell, objFSO suser = “YourAdminAccount@YourDomain.com“ sPass = “YourPassWord” [...]
Answer Question
| May 3, 2012 8:32 PM
VB, VB script
Log in taking up to 5 minutes at remote locations
We have a system that when I look at it locally (on the same LAN as the machine) it logs in quickly and I do not see any issues with performance via WRKSYSACT or WRKACTJOB but when remote locations log in from time to time they get wait times of up to 5 minutes? It [...]
Answer Question
| May 3, 2012 1:31 PM
AS/400 Client Access Macros, iSeries Client Access
We have a system that when I look at it locally (on the same LAN as the machine) it logs in quickly and I do not see any issues with performance via WRKSYSACT or WRKACTJOB but when remote locations log in from time to time they get wait times of up to 5 minutes? It [...]
Answer Question
| May 3, 2012 1:31 PM
AS/400 Client Access Macros, iSeries Client Access
display file setup
Hi. I have been working my way through the following post from this site, but i am stuck on something. I have attempted to set up a display file as per the instructions in the post below, but i am unsure how i create a display file that allows the selection of a library name? [...]
Answer Question
| May 3, 2012 3:17 AM
iSeries Commands, iSeries v6.1
Hi. I have been working my way through the following post from this site, but i am stuck on something. I have attempted to set up a display file as per the instructions in the post below, but i am unsure how i create a display file that allows the selection of a library name? [...]
Answer Question
| May 3, 2012 3:17 AM
iSeries Commands, iSeries v6.1
Custom Reports
My customer service manager wants to to know how many emails each CS agent is handling. She wants report to include agent, message from, message Subject, and date. How can I provide that information from my Domino 8.5 server?
Answer Question
| May 8, 2012 4:33 PM
Lotus Domino 8.5, Lotus Domino reports
My customer service manager wants to to know how many emails each CS agent is handling. She wants report to include agent, message from, message Subject, and date. How can I provide that information from my Domino 8.5 server?
Answer Question
| May 8, 2012 4:33 PM
Lotus Domino 8.5, Lotus Domino reports
hard time reading perl line
can someone help me how to interpret this line? my ($class, $hashref) = @_; my $portfolio = {}; if ($hashref->{portfolio_id}) { ($portfolio) = GEmySQL->get (“select * from portfolio where portfolio.id=$hashref->{portfolio_id}”); } =============== Question: how do you read statement four? From left to right? or Right to left?
Answer Question
| May 3, 2012 3:15 PM
Perl, Unix
can someone help me how to interpret this line? my ($class, $hashref) = @_; my $portfolio = {}; if ($hashref->{portfolio_id}) { ($portfolio) = GEmySQL->get (“select * from portfolio where portfolio.id=$hashref->{portfolio_id}”); } =============== Question: how do you read statement four? From left to right? or Right to left?
Answer Question
| May 3, 2012 3:15 PM
Perl, Unix
Lines of code in body of email
We recently have been having an issue with several vendors’ emails coming through with lines of code in the body. I know that it is a compatibility issue from newer versions of Office compared to our 2003, however we are watching our pennies and 2010 is not feasible at this time. The service patch from [...]
Answer Question
| June 13, 2012 2:55 PM
Microsoft Office 2003, Windows 7
We recently have been having an issue with several vendors’ emails coming through with lines of code in the body. I know that it is a compatibility issue from newer versions of Office compared to our 2003, however we are watching our pennies and 2010 is not feasible at this time. The service patch from [...]
Answer Question
| June 13, 2012 2:55 PM
Microsoft Office 2003, Windows 7
BRMS
what is mean by “object not saved” message in brms logs?and what do when we find object not saved message?
Answer Question
| May 3, 2012 1:01 PM
BRMS Backup
what is mean by “object not saved” message in brms logs?and what do when we find object not saved message?
Answer Question
| May 3, 2012 1:01 PM
BRMS Backup
WCDMA Downlink and Uplink Pole Capacity
Dear all, Can someone tell me how to calculate the maximum theoretical downlink/uplink WCDMA Capacity? I have a network full of Node Bs and BTSs and I would like to calculate the theoretical Max Uplink/Downlink Capacity for network planning purposes. I know there are some equations involved in the chip rate and user data rate! [...]
Answer Question
| April 30, 2012 12:21 PM
BTS, wcdma
Dear all, Can someone tell me how to calculate the maximum theoretical downlink/uplink WCDMA Capacity? I have a network full of Node Bs and BTSs and I would like to calculate the theoretical Max Uplink/Downlink Capacity for network planning purposes. I know there are some equations involved in the chip rate and user data rate! [...]
Answer Question
| April 30, 2012 12:21 PM
BTS, wcdma
FTP
How to download PF from AS400 to text file in PC? I tried reflection.. It worked but having issues with larger files. I tried FTP command get from system. But the text file obtained has lot of special characters which are not present in the database. I gave the conversion mode as ASCII. Any other way [...]
Answer Question
| May 5, 2012 12:00 PM
AS/400, AS/400 FTP, PF file
How to download PF from AS400 to text file in PC? I tried reflection.. It worked but having issues with larger files. I tried FTP command get from system. But the text file obtained has lot of special characters which are not present in the database. I gave the conversion mode as ASCII. Any other way [...]
Answer Question
| May 5, 2012 12:00 PM
AS/400, AS/400 FTP, PF file
library list
pgmrjobd is my job description and lib is qgpl.wtih these two parameters how to get the lib list through rpg program
Answer Question
| May 5, 2012 11:20 AM
AS/400, AS400/RPG
pgmrjobd is my job description and lib is qgpl.wtih these two parameters how to get the lib list through rpg program
Answer Question
| May 5, 2012 11:20 AM
AS/400, AS400/RPG
Block IP address to workgroup nodes
we are using win server 2003 for 250 clients. all systems are in domain control except few systems. some of the computers are still in workgroup. IP addresses dynamically assigned for workgroup systems . when we connect the patch card to the new system it would be connect the network without adding into domain. how [...]
Answer Question
| May 3, 2012 4:23 AM
Windows Server 2003, Workgroup
we are using win server 2003 for 250 clients. all systems are in domain control except few systems. some of the computers are still in workgroup. IP addresses dynamically assigned for workgroup systems . when we connect the patch card to the new system it would be connect the network without adding into domain. how [...]
Answer Question
| May 3, 2012 4:23 AM
Windows Server 2003, Workgroup
User profile exemption
Hi, 1. I would like to inquire if there is a way to exempt a user profile from a disabling, my system QMAXSIGN is 3. 2. Can I recreate a profile like QSECOFR, that can be logged in even disabled on the Controller / Main Display. 3. Is there a way that a single user profile [...]
Answer Question
| May 2, 2012 1:42 AM
iSeries, iSeries applications, iSeries data center
Hi, 1. I would like to inquire if there is a way to exempt a user profile from a disabling, my system QMAXSIGN is 3. 2. Can I recreate a profile like QSECOFR, that can be logged in even disabled on the Controller / Main Display. 3. Is there a way that a single user profile [...]
Answer Question
| May 2, 2012 1:42 AM
iSeries, iSeries applications, iSeries data center
Moving Exchange Mailboxes
I’m using Exchange 2007 on a 2003 server. We have a mailbox database about 26 GB on our D: The D: only has 1.75 GB of space left. Exchange tells me the database has 3GB of whitespace which I’d like to reclaim. I know I can do this using an eseutil defrag, but it would [...]
Answer Question
| May 3, 2012 9:03 PM
Microsoft Exchange 2007, Microsoft Exchange mailbox
I’m using Exchange 2007 on a 2003 server. We have a mailbox database about 26 GB on our D: The D: only has 1.75 GB of space left. Exchange tells me the database has 3GB of whitespace which I’d like to reclaim. I know I can do this using an eseutil defrag, but it would [...]
Answer Question
| May 3, 2012 9:03 PM
Microsoft Exchange 2007, Microsoft Exchange mailbox
SQL 2008 R2 ‘Web Assistant procedures’
exec sp_configure ‘Web Assistant procedures’ When I execute above statement in SQL 2008 R2, I get the follwing error message Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51 The configuration option ‘Web Assistant procedures’ does not exist, or it may be an advanced option. How to correct this error? How do I install [...]
Answer Question
| April 30, 2012 8:07 PM
SQL 2008 R2, SQL 2008 R2 error messages
exec sp_configure ‘Web Assistant procedures’ When I execute above statement in SQL 2008 R2, I get the follwing error message Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51 The configuration option ‘Web Assistant procedures’ does not exist, or it may be an advanced option. How to correct this error? How do I install [...]
Answer Question
| April 30, 2012 8:07 PM
SQL 2008 R2, SQL 2008 R2 error messages
