Do we need to compile LF when its PF changes
Hi, I have one small query. I have changed one PF, do I need to recompile it’s dependent LF(s) ? For e.g I have earlier a PF say PF1 having 4 fields A,B,C,D (with keys A,B) now I have added a new field E. Do I need to recompile its dependent LFs say LF1,LF2.. Appreciate [...]
Answer Question
| July 20, 2012 9:21 AM
as400/DB2
Hi, I have one small query. I have changed one PF, do I need to recompile it’s dependent LF(s) ? For e.g I have earlier a PF say PF1 having 4 fields A,B,C,D (with keys A,B) now I have added a new field E. Do I need to recompile its dependent LFs say LF1,LF2.. Appreciate [...]
Answer Question
| July 20, 2012 9:21 AM
as400/DB2
Private Vlans\
We have an internal Extranet with seperate infrasturcture (switches) Can I combine the extranet onto our customer lan using a private vlan and the customer switches instead of having two seperate switch infrastructure?
Answer Question
| July 19, 2012 7:30 PM
extranet 2960s switches, private vlan
We have an internal Extranet with seperate infrasturcture (switches) Can I combine the extranet onto our customer lan using a private vlan and the customer switches instead of having two seperate switch infrastructure?
Answer Question
| July 19, 2012 7:30 PM
extranet 2960s switches, private vlan
Restore SQL Server 2008 database backup error specified cast is not valid
Received a SQL Serer 2008 database backup newdatabase.bak from a site in UK and attempted to restore it onto my server in USA. Receive error . I assume this is a Server Collation difference issue. Can anyone help me overcome this so that I may be able to restore this backup on my SQL Server [...]
Answer Question
| July 20, 2012 5:37 PM
Server configuration, SQL Server 2008 administration
Received a SQL Serer 2008 database backup newdatabase.bak from a site in UK and attempted to restore it onto my server in USA. Receive error . I assume this is a Server Collation difference issue. Can anyone help me overcome this so that I may be able to restore this backup on my SQL Server [...]
Answer Question
| July 20, 2012 5:37 PM
Server configuration, SQL Server 2008 administration
Importing a .dbf file into IBM DB2 table
I have a .dbf database file I want to upload to our IBM i5 and into a DB2 table. Is there an easy way to do this or am I going to need to convert the .dbf file into a .csv file? I’ve tried using the CPYFRMIMPF command, but have had no such luck. Any [...]
Answer Question
| July 19, 2012 3:02 PM
AS/400, CPYFRMIMPF, DB2, DBF file, i5, V5R4
I have a .dbf database file I want to upload to our IBM i5 and into a DB2 table. Is there an easy way to do this or am I going to need to convert the .dbf file into a .csv file? I’ve tried using the CPYFRMIMPF command, but have had no such luck. Any [...]
Answer Question
| July 19, 2012 3:02 PM
AS/400, CPYFRMIMPF, DB2, DBF file, i5, V5R4
Windows Explorer file system
How can I set Windows Explorer to show only the folders I want.
Answer Question
| July 19, 2012 4:31 AM
Windows Explorer, Windows Explorer folders
How can I set Windows Explorer to show only the folders I want.
Answer Question
| July 19, 2012 4:31 AM
Windows Explorer, Windows Explorer folders
VB6 Search Function
How can I search in vb6 that when I clicked on the search bar, the information will be inserted to the text boxes.
Answer Question
| July 19, 2012 3:52 AM
Search, Search string, VB6
How can I search in vb6 that when I clicked on the search bar, the information will be inserted to the text boxes.
Answer Question
| July 19, 2012 3:52 AM
Search, Search string, VB6
Selecting data to delete from column & rows
I have a sheet that shows me supplier codes – example – these are four digit numbers like 1501 , 1524 , 1701 My problem is I only want to see data from certain suppliers. I have thousands on the sheet that runs daily, but I want to extract data from selected suppliers in column [...]
Answer Question
| July 19, 2012 9:50 PM
VBA, VBA functions
I have a sheet that shows me supplier codes – example – these are four digit numbers like 1501 , 1524 , 1701 My problem is I only want to see data from certain suppliers. I have thousands on the sheet that runs daily, but I want to extract data from selected suppliers in column [...]
Answer Question
| July 19, 2012 9:50 PM
VBA, VBA functions
lotus notes
anyone can help me some times in lotus notes whenever user try to login in lotus notes the error comes unknow erroe from icc i have done all the related things like copy another copy of icc file it work for some time but after restart the system same error is coming . i also [...]
Answer Question
| July 18, 2012 5:45 PM
LotusNotes Web Application
anyone can help me some times in lotus notes whenever user try to login in lotus notes the error comes unknow erroe from icc i have done all the related things like copy another copy of icc file it work for some time but after restart the system same error is coming . i also [...]
Answer Question
| July 18, 2012 5:45 PM
LotusNotes Web Application
Excel Quickbooks Update Report
I was wondering what the Quickbooks Update Report in Excel does? I was going to try it but I am on a work computer and was afraid to try it without knowing what it does first.
Answer Question
| July 18, 2012 1:15 PM
Microsoft Excel, QuickBooks
I was wondering what the Quickbooks Update Report in Excel does? I was going to try it but I am on a work computer and was afraid to try it without knowing what it does first.
Answer Question
| July 18, 2012 1:15 PM
Microsoft Excel, QuickBooks
How Do I install additional SAS hard drives on an HP ML370G6
How do I install additional SAS hard drives on an HP ML 370 G6 server without losing my data like what happened to me before.
Answer Question
| July 18, 2012 12:43 PM
HP ML370G6 server.
How do I install additional SAS hard drives on an HP ML 370 G6 server without losing my data like what happened to me before.
Answer Question
| July 18, 2012 12:43 PM
HP ML370G6 server.
Can not Connect PC to Cisco 1841 Router!
Hello I have a 1841 router.It has two F/E ports.One of them is connected to an ADSL modem and the other to my PC through crossover RJ-45 cable.The problem is that the connection is not active and light are off.and also I get network disconnection icon in windows.I tested the PC with other networks and [...]
Answer Question
| July 18, 2012 11:08 AM
Cisco 1841 router
Hello I have a 1841 router.It has two F/E ports.One of them is connected to an ADSL modem and the other to my PC through crossover RJ-45 cable.The problem is that the connection is not active and light are off.and also I get network disconnection icon in windows.I tested the PC with other networks and [...]
Answer Question
| July 18, 2012 11:08 AM
Cisco 1841 router
SST QSECOFR Disabled
My QSECOFR Profile has been disabled after couple of wrong attempts with in correct password.Now,I forgot what actually the password is …I’m trying to force DST with option 21 from HMC Interface to reset SST QSECOFR Profile…I’m getting DST log on screen when i force DST.Here also I forgot what is the Password for SST/DST… [...]
Answer Question
| July 18, 2012 7:38 AM
AS/400, DST, iSeries AS/400, SST
My QSECOFR Profile has been disabled after couple of wrong attempts with in correct password.Now,I forgot what actually the password is …I’m trying to force DST with option 21 from HMC Interface to reset SST QSECOFR Profile…I’m getting DST log on screen when i force DST.Here also I forgot what is the Password for SST/DST… [...]
Answer Question
| July 18, 2012 7:38 AM
AS/400, DST, iSeries AS/400, SST
I’m unable to access Internet after configuring TMG 2010
Dear Sir, I’ve configured TMG as an Edge Firewall and after configuring I’m unable to access Internet. Following are the configurations I made: Internal Network Adapter Settings: IP: 192.168.1.2 Subnet Mask: 255.255.255.0 Gateway : None DNS: 192.168.1.1 192.168.1.1 is my Domain Controller where I’m also using DHCP. External Network Adapter Settings: IP: 192.168.0.101 Subnet Mask: [...]
Answer Question
| July 18, 2012 3:49 AM
threat management gateway
Dear Sir, I’ve configured TMG as an Edge Firewall and after configuring I’m unable to access Internet. Following are the configurations I made: Internal Network Adapter Settings: IP: 192.168.1.2 Subnet Mask: 255.255.255.0 Gateway : None DNS: 192.168.1.1 192.168.1.1 is my Domain Controller where I’m also using DHCP. External Network Adapter Settings: IP: 192.168.0.101 Subnet Mask: [...]
Answer Question
| July 18, 2012 3:49 AM
threat management gateway
storage group
Hi, Can we add multiple hosts to a storage group? I know a host cannot add to more than one storage group at time, however not sure if two servers can add to a single storage group in clariion.
Answer Question
| July 17, 2012 5:36 PM
Storage Group
Hi, Can we add multiple hosts to a storage group? I know a host cannot add to more than one storage group at time, however not sure if two servers can add to a single storage group in clariion.
Answer Question
| July 17, 2012 5:36 PM
Storage Group
connection manager for Sql server 7 database in ssis 2012
Hi, I created a connection manager to connect to sql server 7 database. After entering user name and password, no databases appear in the list. Does SSIS 2012 support sql server 7? Thanks.
Answer Question
| July 17, 2012 12:22 PM
ssis 2012
Hi, I created a connection manager to connect to sql server 7 database. After entering user name and password, no databases appear in the list. Does SSIS 2012 support sql server 7? Thanks.
Answer Question
| July 17, 2012 12:22 PM
ssis 2012
Lotus Notes disappearing
Hi, i have a problem with lotus notes clients, after providing my user credentials lotus notes is completely disappearing from the screen, i tried closing from the task manager processes, again it open and after the password is entered it goes blank, i also tried un-installing antivirus software, i also uninstalled and re-installed lotus application [...]
Answer Question
| July 18, 2012 10:34 AM
Lotus Notes 8.0.2
Hi, i have a problem with lotus notes clients, after providing my user credentials lotus notes is completely disappearing from the screen, i tried closing from the task manager processes, again it open and after the password is entered it goes blank, i also tried un-installing antivirus software, i also uninstalled and re-installed lotus application [...]
Answer Question
| July 18, 2012 10:34 AM
Lotus Notes 8.0.2
Insured Name not displayed properly
I have a program which accepts inputs from the user on the screen.Accordingly it would display. Problem – User enters CHRIS(only accepts capital). When user hits enter it is displaying insured name starting with CHRIS only. Though database is having both CHRIS and Chris. Is there any built-in-functions to trap both CHRIS and Chris and [...]
Answer Question
| July 17, 2012 9:32 AM
RPGILE
I have a program which accepts inputs from the user on the screen.Accordingly it would display. Problem – User enters CHRIS(only accepts capital). When user hits enter it is displaying insured name starting with CHRIS only. Though database is having both CHRIS and Chris. Is there any built-in-functions to trap both CHRIS and Chris and [...]
Answer Question
| July 17, 2012 9:32 AM
RPGILE
I have enabled sftp between iseries servers, is it possible to conifgure sftp between iseries server and windows
We have users moving objects from iseries to windows and viceverso. Need to secure them using sftp. Is it possible.? If yes, can i have the steps to configure the same.
Answer Question
| July 17, 2012 7:19 AM
iseries and windows, SFTP
We have users moving objects from iseries to windows and viceverso. Need to secure them using sftp. Is it possible.? If yes, can i have the steps to configure the same.
Answer Question
| July 17, 2012 7:19 AM
iseries and windows, SFTP
Is it possible to give a user access to sql screen wherein he is allowed only to use select commands
Is it possible to give a user access to sql screen wherein he is allowed only to use select commands. We have a team of users who use a set of 10 – 15 select commands on daily basis.
Answer Question
| July 17, 2012 7:06 AM
AS/400, iSeries, select command, sql command access
Is it possible to give a user access to sql screen wherein he is allowed only to use select commands. We have a team of users who use a set of 10 – 15 select commands on daily basis.
Answer Question
| July 17, 2012 7:06 AM
AS/400, iSeries, select command, sql command access
Get list of files used in a code
Hi Is there any way we can get the list of files used in an RPG/RPGLE code. I want to check the Level Check Identifier Code used in my file (Checked using DSPFD command) with the Level Check Identifier of same file used in program. Thanks
Answer Question
| July 16, 2012 5:05 PM
DDS, Level Check, RPG
Hi Is there any way we can get the list of files used in an RPG/RPGLE code. I want to check the Level Check Identifier Code used in my file (Checked using DSPFD command) with the Level Check Identifier of same file used in program. Thanks
Answer Question
| July 16, 2012 5:05 PM
DDS, Level Check, RPG
