Query against User Profiles
I was trying to omit some of the user profiles,which generally starts with KMAN*,TMAN*,CMAN* from the list of all user profiles (DSPUSRPRF USRPRF(*ALL) TYPE(*BASIC) OUTPUT(*OUTFILE). I’m querying this against to a outfile,i was able to select the columns what i want,but i couln’t find option/feature to omit certain user profiles which start generally with common [...]
Answer Question
| April 11, 2012 4:55 AM
AS400 -WRKQRY, iSeries V6R1
I was trying to omit some of the user profiles,which generally starts with KMAN*,TMAN*,CMAN* from the list of all user profiles (DSPUSRPRF USRPRF(*ALL) TYPE(*BASIC) OUTPUT(*OUTFILE). I’m querying this against to a outfile,i was able to select the columns what i want,but i couln’t find option/feature to omit certain user profiles which start generally with common [...]
Answer Question
| April 11, 2012 4:55 AM
AS400 -WRKQRY, iSeries V6R1
Domain Admin Permissions to Folder Redirections
Hello, I am working with a clients serverand have ran into some issues. The server is SBS 2008. I need to give the Domain Admin full control of the following directory which has subfolders for the users home folder. c:usersFolderRedirections. What is the easiest way to give the domain admin full control of this top [...]
Answer Question
| April 11, 2012 2:27 AM
SBS 2008, SBS 2008 Migration
Hello, I am working with a clients serverand have ran into some issues. The server is SBS 2008. I need to give the Domain Admin full control of the following directory which has subfolders for the users home folder. c:usersFolderRedirections. What is the easiest way to give the domain admin full control of this top [...]
Answer Question
| April 11, 2012 2:27 AM
SBS 2008, SBS 2008 Migration
How do I subtract 3 days from current date only when current day = 2, so that I retrieve the previous Fridays date?
I am new to using T-SQL, so there is probably an easy way to accomplish this, but I can’t seem to get it right. I want to retrieve the previous day’s date (requires a weekday) to use as a comparsioin to a date field in the table, format is YYYYMMDD. When the current date is [...]
Answer Question
| April 10, 2012 7:59 PM
T-SQL, T-SQL 2008 R2
I am new to using T-SQL, so there is probably an easy way to accomplish this, but I can’t seem to get it right. I want to retrieve the previous day’s date (requires a weekday) to use as a comparsioin to a date field in the table, format is YYYYMMDD. When the current date is [...]
Answer Question
| April 10, 2012 7:59 PM
T-SQL, T-SQL 2008 R2
How to add a user
Can I copy a user prf and make a new user from that?
Answer Question
| May 3, 2012 7:23 PM
AS/400-Users, WRKUSRPRF
Can I copy a user prf and make a new user from that?
Answer Question
| May 3, 2012 7:23 PM
AS/400-Users, WRKUSRPRF
iSeries Access *.OWS File
We are changing the iSeries IP address in company with 3000+ users connecting with different versions of iSeries Access for Windows. Most of these configurations were done with system IP rather than host name. Can all of these be changed with LAN Desk and if so how?
Answer Question
| April 10, 2012 1:49 PM
iSeries Access, LAN Desk
We are changing the iSeries IP address in company with 3000+ users connecting with different versions of iSeries Access for Windows. Most of these configurations were done with system IP rather than host name. Can all of these be changed with LAN Desk and if so how?
Answer Question
| April 10, 2012 1:49 PM
iSeries Access, LAN Desk
Remote systems shutdown through server
Hi, I need to set about 60% (about 50) of the PC’s in our network to automatically shutdown at 8pm every night. I am running Windows server 2003, and the clients are all Windows XP. Can someone tell me the best way to do this. Thanks Ramachandrna
Answer Question
| April 10, 2012 12:09 PM
Windows Server 2003, Windows XP
Hi, I need to set about 60% (about 50) of the PC’s in our network to automatically shutdown at 8pm every night. I am running Windows server 2003, and the clients are all Windows XP. Can someone tell me the best way to do this. Thanks Ramachandrna
Answer Question
| April 10, 2012 12:09 PM
Windows Server 2003, Windows XP
communication between 2 vlans
Hi , I have cisco 3560 series poe-24 switch with and created different vlan1 Vlan 1 - 1-10 vlan 2 – 11 – 20 Vlan 3 21 – 24 i connected 3 pcs to each vlan with ips vlan 1 pc - 192.168.1.100 (connected to port 9) vlan 2 pc – 192.168.2.100 ( connected to [...]
Answer Question
| June 5, 2012 11:45 AM
Cisco 3560, Cisco VLAN
Hi , I have cisco 3560 series poe-24 switch with and created different vlan1 Vlan 1 - 1-10 vlan 2 – 11 – 20 Vlan 3 21 – 24 i connected 3 pcs to each vlan with ips vlan 1 pc - 192.168.1.100 (connected to port 9) vlan 2 pc – 192.168.2.100 ( connected to [...]
Answer Question
| June 5, 2012 11:45 AM
Cisco 3560, Cisco VLAN
RUNRMTCMD
I am trying to execute RUNRMTCMD command from CLP on one partition to another partition using *SNA method. I can execute this CLP without any error when I specify my user id and password on remote user id and remote password parameters. When I try to execute the same CLP by specifying another user id [...]
Answer Question
| April 10, 2012 7:37 AM
AS400 CLP, AS400 V6R1M1, RUNRMTCMD
I am trying to execute RUNRMTCMD command from CLP on one partition to another partition using *SNA method. I can execute this CLP without any error when I specify my user id and password on remote user id and remote password parameters. When I try to execute the same CLP by specifying another user id [...]
Answer Question
| April 10, 2012 7:37 AM
AS400 CLP, AS400 V6R1M1, RUNRMTCMD
subfile
did the above steps but its not working… Example:: —————————————– FLD1 FLD2 FLD3 AAA AAAA AAAAA AAA AAAA AAAAA AAA AAAA AAAAA rrn = 3 —————————————– BB ______ _________ i need to filter the records having the value BB ,but there is no records having that values.. There is no records having the value as [...]
Answer Question
| April 13, 2012 6:49 AM
AS/400, AS/400 Subfiles
did the above steps but its not working… Example:: —————————————– FLD1 FLD2 FLD3 AAA AAAA AAAAA AAA AAAA AAAAA AAA AAAA AAAAA rrn = 3 —————————————– BB ______ _________ i need to filter the records having the value BB ,but there is no records having that values.. There is no records having the value as [...]
Answer Question
| April 13, 2012 6:49 AM
AS/400, AS/400 Subfiles
Citrix Server is not accepting connection
Hi, One of the client is geting “citrix ssl server is not accepting connection” error.Can anyone please advise?
Answer Question
| April 9, 2012 5:38 AM
Citrix XenApp, Windows Server 2003
Hi, One of the client is geting “citrix ssl server is not accepting connection” error.Can anyone please advise?
Answer Question
| April 9, 2012 5:38 AM
Citrix XenApp, Windows Server 2003
Unable to connect to AS/400 server
I have downloaded as400 emulator TN5250 (free trial version). After installing the setup it took the IP address automatically. But if I say connect by giving a session name, it says “Sorry, unable to connect to the selected mainframe”
Answer Question
| April 12, 2012 11:11 AM
AS/400 connection error, AS/400 Emulator
I have downloaded as400 emulator TN5250 (free trial version). After installing the setup it took the IP address automatically. But if I say connect by giving a session name, it says “Sorry, unable to connect to the selected mainframe”
Answer Question
| April 12, 2012 11:11 AM
AS/400 connection error, AS/400 Emulator
condition based color changing of labels
Imports System.Data.OleDb Imports System.Data Imports System.Threading Imports System.Data.SqlClient Public Class Form1 Dim bm As BindingManagerBase Dim ds As New DataSet Dim adp As OleDb.OleDbDataAdapter Sub showrecord(ByVal pos As Integer) Button1.Text = ds.Tables(0).Rows(pos)("Question") Button2.Text = ds.Tables(0).Rows(pos)("Option1") [...]
Answer Question
| April 9, 2012 5:52 AM
VB.NET, Visual Studio 2008 Professional
Imports System.Data.OleDb Imports System.Data Imports System.Threading Imports System.Data.SqlClient Public Class Form1 Dim bm As BindingManagerBase Dim ds As New DataSet Dim adp As OleDb.OleDbDataAdapter Sub showrecord(ByVal pos As Integer) Button1.Text = ds.Tables(0).Rows(pos)("Question") Button2.Text = ds.Tables(0).Rows(pos)("Option1") [...]
Answer Question
| April 9, 2012 5:52 AM
VB.NET, Visual Studio 2008 Professional
I would like to send a attachment with an user supplied subject line and long message
What needs to be done in order to have all three: user supplied subject line, a long message and an attached file? When a SND DST command is called with *DOC TYPE, the system uses the attached file name in the subject and no long message can be used.
Answer Question
| October 29, 2012 3:49 AM
Marketing Technology
What needs to be done in order to have all three: user supplied subject line, a long message and an attached file? When a SND DST command is called with *DOC TYPE, the system uses the attached file name in the subject and no long message can be used.
Answer Question
| October 29, 2012 3:49 AM
Marketing Technology
FTP- options for receiving files
Hello all, We have an FTP client who is putting 4 files at a time on their server folder for us to pick up. I am running into a little issue and am looking for options. They will not delete the files from their folder after we get them. We do not have authority to [...]
Answer Question
| April 11, 2012 5:39 PM
AS/400 FTP, AS/400 v5r4
Hello all, We have an FTP client who is putting 4 files at a time on their server folder for us to pick up. I am running into a little issue and am looking for options. They will not delete the files from their folder after we get them. We do not have authority to [...]
Answer Question
| April 11, 2012 5:39 PM
AS/400 FTP, AS/400 v5r4
Socket() “too many files open” error – but no files are open
I am writing an RPG Sockets program and when I call the “C” socket() function, I am receiving an “EMFILE 3452 Too many open files for this process” error. However, there are no other files open in this program. The code and prototypes are exactly the same as an existing “C” client that is working. [...]
Answer Question
| April 6, 2012 8:52 PM
AS/400, AS400. RPG
I am writing an RPG Sockets program and when I call the “C” socket() function, I am receiving an “EMFILE 3452 Too many open files for this process” error. However, there are no other files open in this program. The code and prototypes are exactly the same as an existing “C” client that is working. [...]
Answer Question
| April 6, 2012 8:52 PM
AS/400, AS400. RPG
Error during run time
Dear experts, I am developing a website in ASP.NET using C# and I am facing the following error : Invalid postback or callback argument. Event validation is enabled using in configuration or <%@ Page EnableEventValidation=”true” %> in a page. For security purposes, this feature verifies that arguments to postback or callback events originate from the [...]
Answer Question
| April 17, 2012 6:45 PM
ASP.NET, C#
Dear experts, I am developing a website in ASP.NET using C# and I am facing the following error : Invalid postback or callback argument. Event validation is enabled using in configuration or <%@ Page EnableEventValidation=”true” %> in a page. For security purposes, this feature verifies that arguments to postback or callback events originate from the [...]
Answer Question
| April 17, 2012 6:45 PM
ASP.NET, C#
RPGLE program described files
Why is this so diffcult to space so it is readable? FILE01 has some records that need to be copied to FILE02 and deleted from FILE01. This is my error: *RNF7260 30 3 The Factor 2 operand is not valid for the specified operation. What do I need to fix? FFILE01 UF F 2300 [...]
Answer Question
| April 10, 2012 4:50 PM
iSeries RPGLE, RPGLE Program
Why is this so diffcult to space so it is readable? FILE01 has some records that need to be copied to FILE02 and deleted from FILE01. This is my error: *RNF7260 30 3 The Factor 2 operand is not valid for the specified operation. What do I need to fix? FFILE01 UF F 2300 [...]
Answer Question
| April 10, 2012 4:50 PM
iSeries RPGLE, RPGLE Program
Commitment Control in RPGLE Program
Hi, Is there any way that we can handle commitment control in RPGLE program i.e. if program dumps at some point then we rollback the updates done on other files in previous steps. Actually I am calling rpgle program from outside iSeries. If any error occurs on external interface then I have the way to [...]
Answer Question
| April 5, 2012 3:25 PM
AS400 RPGLE, RPGLE
Hi, Is there any way that we can handle commitment control in RPGLE program i.e. if program dumps at some point then we rollback the updates done on other files in previous steps. Actually I am calling rpgle program from outside iSeries. If any error occurs on external interface then I have the way to [...]
Answer Question
| April 5, 2012 3:25 PM
AS400 RPGLE, RPGLE
VBA – Delete rows if they meet a certain criteria
Hi, I am trying to write a code to delete rows that meet a certain criteria. I have a large amount of data in a spreasheet and all of the columns contain different metrics. I want the code to go through all of the rows and delete the rows that have a number in column [...]
Answer Question
| April 5, 2012 3:19 PM
Microsoft Office VBA, VBA
Hi, I am trying to write a code to delete rows that meet a certain criteria. I have a large amount of data in a spreasheet and all of the columns contain different metrics. I want the code to go through all of the rows and delete the rows that have a number in column [...]
Answer Question
| April 5, 2012 3:19 PM
Microsoft Office VBA, VBA
Uploading xml files to my website
Hello, I am trying to verify Bing Webmaster. I have downloaded BingSiteAuth.xml, opened it in notepad and tried to save it – as I would htm files but it will not work. Can someone please give me step by step instructions….SIMPLE – for I am not computer savvy. Much appreciated as this will stop me from [...]
Answer Question
| October 29, 2012 12:07 PM
Marketing Technology
Hello, I am trying to verify Bing Webmaster. I have downloaded BingSiteAuth.xml, opened it in notepad and tried to save it – as I would htm files but it will not work. Can someone please give me step by step instructions….SIMPLE – for I am not computer savvy. Much appreciated as this will stop me from [...]
Answer Question
| October 29, 2012 12:07 PM
Marketing Technology
