solution on pos terminals
need a solution on pos terminals connection to my database and network providers and switch company for airtime vending and credit/debit card transaction
Answer Question
| January 26, 2005 8:25 PM
DataCenter, E-business
need a solution on pos terminals connection to my database and network providers and switch company for airtime vending and credit/debit card transaction
Answer Question
| January 26, 2005 8:25 PM
DataCenter, E-business
Microsoft Access. Passing an ID/value to a subform. or between forms
Hello Everyone. I am using MS Access 2000 I have a form (frm_cboclient)that has a combobox on it that I populate by querying a client table for clientID and client name. What I would like to do then is have a subform that will display all my order infomration from my order table, where the [...]
Answer Question
| February 2, 2005 11:39 PM
Development, E-business, Microsoft .NET, Programming Languages, SQL, VBA, VBScript, Visual Basic, Web development tools
Hello Everyone. I am using MS Access 2000 I have a form (frm_cboclient)that has a combobox on it that I populate by querying a client table for clientID and client name. What I would like to do then is have a subform that will display all my order infomration from my order table, where the [...]
Answer Question
| February 2, 2005 11:39 PM
Development, E-business, Microsoft .NET, Programming Languages, SQL, VBA, VBScript, Visual Basic, Web development tools
Outer Join issues in Crystal Reports 10
I am a new user of Crystal Reports 10. My problem is I have an outer join and a condition on the table I am outer joined to. SELECT TRXL.CUSTOMER_TRX_ID , TRXL.CUSTOMER_TRX_LINE_ID , TRXL.INVENTORY_ITEM_ID , TRX.BILL_TO_CUSTOMER_ID , TRXL.DESCRIPTION , NVL(TRXL.QUANTITY_ORDERED,1) , RF.GIFT_AMOUNT FROM AR.RA_CUSTOMER_TRX_LINES_ALL TRXL , XXWV.XXWV_HIST_RFACT RF WHERE 1 = 1 AND TRXL.CUSTOMER_TRX_LINE_ID = [...]
Answer Question
| February 10, 2005 11:12 AM
Crystal Reports
I am a new user of Crystal Reports 10. My problem is I have an outer join and a condition on the table I am outer joined to. SELECT TRXL.CUSTOMER_TRX_ID , TRXL.CUSTOMER_TRX_LINE_ID , TRXL.INVENTORY_ITEM_ID , TRX.BILL_TO_CUSTOMER_ID , TRXL.DESCRIPTION , NVL(TRXL.QUANTITY_ORDERED,1) , RF.GIFT_AMOUNT FROM AR.RA_CUSTOMER_TRX_LINES_ALL TRXL , XXWV.XXWV_HIST_RFACT RF WHERE 1 = 1 AND TRXL.CUSTOMER_TRX_LINE_ID = [...]
Answer Question
| February 10, 2005 11:12 AM
Crystal Reports
Deleting journal receivers
HI, When I try to delete a journal receiver that hasn’t been saved, I get the “never fully saved” message even though I’m using DLTOPT(*IGNINQMSG) Does anyone have a piece of code that will get rid of receivers no matter what? E.G. not saved, remote, attached…… Thanks
Answer Question
| October 11, 2010 11:04 AM
Backup & recovery, Database Management Systems, DB2, DB2 administration, Hardware, i5, iSeries, OS/400, Performance/Tuning, Servers, tips and tricks, Tools
HI, When I try to delete a journal receiver that hasn’t been saved, I get the “never fully saved” message even though I’m using DLTOPT(*IGNINQMSG) Does anyone have a piece of code that will get rid of receivers no matter what? E.G. not saved, remote, attached…… Thanks
Answer Question
| October 11, 2010 11:04 AM
Backup & recovery, Database Management Systems, DB2, DB2 administration, Hardware, i5, iSeries, OS/400, Performance/Tuning, Servers, tips and tricks, Tools
SEM version 4.0
Has anyone upgraded to SEM version 4.0? We are on 3.1b. Can you tell me what pros and cons you have found. Thanks.
Answer Question
| January 18, 2005 9:37 AM
ERP
Has anyone upgraded to SEM version 4.0? We are on 3.1b. Can you tell me what pros and cons you have found. Thanks.
Answer Question
| January 18, 2005 9:37 AM
ERP
Use of reuse_alv_extract_save & reuse_alv_extract_load function modules in SAP-ABAP.
Can anyone explain me the purpose of reuse_alv_extract_save & reuse_alv_extract_load function modules.Its very urgent
Answer Question
| January 12, 2005 4:55 AM
ERP
Can anyone explain me the purpose of reuse_alv_extract_save & reuse_alv_extract_load function modules.Its very urgent
Answer Question
| January 12, 2005 4:55 AM
ERP
REXEC from IBM Mainframe
How do you run a batch script on an NT Server using REXEC?
Answer Question
| February 2, 2005 11:34 AM
Integration with other platforms
How do you run a batch script on an NT Server using REXEC?
Answer Question
| February 2, 2005 11:34 AM
Integration with other platforms
How to monitor and manage lan gateway from a helius router?
Hi Everyone, I am trying to filter/manage a gateway through a helius router for directway. We are running windows 2000 server with all xp clients, around 50 of them. We have active directory running with the domain controller handing out dns and dhcp to clients. All clients are pointing to the helius router for their [...]
Answer Question
| January 10, 2005 3:32 AM
Application software, Auditing, DataCenter, Integration/Connectivity, Linux, Networking Products, Routers, Security, Security management, Servers, System monitoring, System utilities, Unix, Windows 2000 Server, Windows client administration and maintenance, Windows XP
Hi Everyone, I am trying to filter/manage a gateway through a helius router for directway. We are running windows 2000 server with all xp clients, around 50 of them. We have active directory running with the domain controller handing out dns and dhcp to clients. All clients are pointing to the helius router for their [...]
Answer Question
| January 10, 2005 3:32 AM
Application software, Auditing, DataCenter, Integration/Connectivity, Linux, Networking Products, Routers, Security, Security management, Servers, System monitoring, System utilities, Unix, Windows 2000 Server, Windows client administration and maintenance, Windows XP
Database choice for web application
I am building web applications, using ASP.NET, each of which must store/retrieve data to/from a set of central databases. I basically have a choice between using MS Access or SQL Server and could use some advice about which to go for or what criteria to apply. Bear in mind that there will be several databases [...]
Answer Question
| January 24, 2005 4:28 AM
Database Management Systems, DataCenter, Development, SQL Server, Web development tools, Web services
I am building web applications, using ASP.NET, each of which must store/retrieve data to/from a set of central databases. I basically have a choice between using MS Access or SQL Server and could use some advice about which to go for or what criteria to apply. Bear in mind that there will be several databases [...]
Answer Question
| January 24, 2005 4:28 AM
Database Management Systems, DataCenter, Development, SQL Server, Web development tools, Web services
free websites and mailservers
hello all, this question will appear childish to u but i m very curious to know.millions of people surf the internet daily.all the websites we visit, most of the mail servers we use,and bulk of information we gather, no one pays for it.how the sites or servers benefited then?i mean why those web sites and [...]
Answer Question
| January 4, 2005 12:39 AM
DataCenter, E-business, Partner facing, Training
hello all, this question will appear childish to u but i m very curious to know.millions of people surf the internet daily.all the websites we visit, most of the mail servers we use,and bulk of information we gather, no one pays for it.how the sites or servers benefited then?i mean why those web sites and [...]
Answer Question
| January 4, 2005 12:39 AM
DataCenter, E-business, Partner facing, Training
Scalar functions in GROUP BY
Is there a reason why I cannot use a SCALAR function in a Group BY clause? I have a table with a column that is of type timestamp. I want to get a count of all dates for which there are multiple rows. So I devise a query of the sort SELECT COUNT(*), DAYS(TMSTP_COL) FROM [...]
Answer Question
| October 21, 2009 2:15 PM
DB2, OS/390, UDB for mainframe, z/OS
Is there a reason why I cannot use a SCALAR function in a Group BY clause? I have a table with a column that is of type timestamp. I want to get a count of all dates for which there are multiple rows. So I devise a query of the sort SELECT COUNT(*), DAYS(TMSTP_COL) FROM [...]
Answer Question
| October 21, 2009 2:15 PM
DB2, OS/390, UDB for mainframe, z/OS
Slow boot-up in win xp home edition
My notebook(40gb HDD, 256mb RAM)with win xp home edition has become dramatically slow in last 1-2 months. It takes more than 5 minutes to boot even after I removed everything from startup group using msconfig. The initial screen (win XP home) stays atleast 2-3minutes. How can I manage this? Is there something wrong with HDD [...]
Answer Question
| November 2, 2011 4:24 AM
Administration, Application software, Clarify Inc., Data analysis, Data center operations, Database Management Systems, DataCenter, Desktop management applications, Desktops, Disaster Recovery, ERP, FAT and NTFS, Graphical User Interfaces, Hardware, Help Desk, Information risk management, Installation, IT architecture, Microsoft Windows, Network management software, Networking, Operating system platforms, Power management, Registry, Servers, Service and support, Services, Software, Storage, System utilities, Tech support, Third-party services, Vendor support, Vulnerability Assessment & Audit, Windows, Windows 2000 desktop, Windows 95/98, Windows client administration and maintenance, Windows XP
My notebook(40gb HDD, 256mb RAM)with win xp home edition has become dramatically slow in last 1-2 months. It takes more than 5 minutes to boot even after I removed everything from startup group using msconfig. The initial screen (win XP home) stays atleast 2-3minutes. How can I manage this? Is there something wrong with HDD [...]
Answer Question
| November 2, 2011 4:24 AM
Administration, Application software, Clarify Inc., Data analysis, Data center operations, Database Management Systems, DataCenter, Desktop management applications, Desktops, Disaster Recovery, ERP, FAT and NTFS, Graphical User Interfaces, Hardware, Help Desk, Information risk management, Installation, IT architecture, Microsoft Windows, Network management software, Networking, Operating system platforms, Power management, Registry, Servers, Service and support, Services, Software, Storage, System utilities, Tech support, Third-party services, Vendor support, Vulnerability Assessment & Audit, Windows, Windows 2000 desktop, Windows 95/98, Windows client administration and maintenance, Windows XP
Mainframe Testing Tools
My shop is currently looking for testing packages for batch (mostly cobol, some assembler) applications as well as our online CICS applications. We are z/OS shop using IMS and a very limited amount of DB2. We are looking at CA-InterTest, Xpediter, and SmartTest. In addition to the usual testing and de-bugging assistance, we would most [...]
Answer Question
| September 16, 2005 6:00 PM
390, COBOL, DB2, Functional, Mainframe, Performance/Load, Software testing, Software testing tools
My shop is currently looking for testing packages for batch (mostly cobol, some assembler) applications as well as our online CICS applications. We are z/OS shop using IMS and a very limited amount of DB2. We are looking at CA-InterTest, Xpediter, and SmartTest. In addition to the usual testing and de-bugging assistance, we would most [...]
Answer Question
| September 16, 2005 6:00 PM
390, COBOL, DB2, Functional, Mainframe, Performance/Load, Software testing, Software testing tools
Importing/copying external EBCDIC files to DB2 on iseries
This seems kind of obvious, but we can’t figure it out. Another company has sent us (via email) an EBCDIC file and we want to load it on to our iseries. What’s the ticket? We’ve tried CPYFRMPCD and a couple of other things, but we get conversion errors? Any thoughts out there?
Answer Question
| October 10, 2010 4:48 PM
AS/400, COBOL, DB2, Development
This seems kind of obvious, but we can’t figure it out. Another company has sent us (via email) an EBCDIC file and we want to load it on to our iseries. What’s the ticket? We’ve tried CPYFRMPCD and a couple of other things, but we get conversion errors? Any thoughts out there?
Answer Question
| October 10, 2010 4:48 PM
AS/400, COBOL, DB2, Development
Triggers
Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks
Answer Question
| December 27, 2004 2:35 PM
Architecture/Design, Database Management Systems, DB2, DB2 Implementation, i5, iSeries, OS/400, tips and tricks, Tools
Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks
Answer Question
| December 27, 2004 2:35 PM
Architecture/Design, Database Management Systems, DB2, DB2 Implementation, i5, iSeries, OS/400, tips and tricks, Tools
Triggers
Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks
Answer Question
| October 19, 2009 2:35 PM
Architecture/Design, Database Management Systems, DB2, DB2 Implementation, i5, iSeries, OS/400, tips and tricks, Tools
Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks
Answer Question
| October 19, 2009 2:35 PM
Architecture/Design, Database Management Systems, DB2, DB2 Implementation, i5, iSeries, OS/400, tips and tricks, Tools
Windows media audio codec
Hi, Sometimes in some programs(for example Training CD’s) there is no sound from my sound card!!!!!!!I try this program on another computer and it has sound!!!!!!! In control panel->sound->audio codec->properties there are some compression driver for sound for example “Windows media audio codec” ,other computer has it but my computer doesn’t, how can I add [...]
Answer Question
| January 2, 2005 4:49 AM
DataCenter, Desktops, Development, ERP, Hardware, Intel PC hardware, Operating system platforms, Tech support, Windows 2000 desktop
Hi, Sometimes in some programs(for example Training CD’s) there is no sound from my sound card!!!!!!!I try this program on another computer and it has sound!!!!!!! In control panel->sound->audio codec->properties there are some compression driver for sound for example “Windows media audio codec” ,other computer has it but my computer doesn’t, how can I add [...]
Answer Question
| January 2, 2005 4:49 AM
DataCenter, Desktops, Development, ERP, Hardware, Intel PC hardware, Operating system platforms, Tech support, Windows 2000 desktop
vpn through s-box firewall of checkpoint
i’m try to create a vpn from the internet to my “small buisness server 2003″ that act as vpn server without any luck, if i try to connect to my server from the internal network it’s work just fine, iv’e mapped the correct ports according to the microsoft article that say to forward port 1723 [...]
Answer Question
| June 29, 2012 6:01 PM
Administration, Application security, Architecture/Design, Database, Documentation, Encryption, Exchange, Features/Functionality, Firewalls, Forensics, Help Desk, Implementation, Incident response, Installation, Instant Messaging, Intrusion management, IT architecture, Knowledge management applications, Network security, Planning, Secure Coding, Security, Security management, Security products, Service and support, Spam, VPN, Wireless
i’m try to create a vpn from the internet to my “small buisness server 2003″ that act as vpn server without any luck, if i try to connect to my server from the internal network it’s work just fine, iv’e mapped the correct ports according to the microsoft article that say to forward port 1723 [...]
Answer Question
| June 29, 2012 6:01 PM
Administration, Application security, Architecture/Design, Database, Documentation, Encryption, Exchange, Features/Functionality, Firewalls, Forensics, Help Desk, Implementation, Incident response, Installation, Instant Messaging, Intrusion management, IT architecture, Knowledge management applications, Network security, Planning, Secure Coding, Security, Security management, Security products, Service and support, Spam, VPN, Wireless
Wireless University
I work at a large, urban university. We are looking to upgrade our whole IT infrastructure. We hired a consultant group and they feel it will take a quarter of a billion dollars to accomplish it. I want to find cheap, faster, better ways to upgrade. Also, I want to serve students, faculty and admin., [...]
Answer Question
| December 30, 2004 5:00 PM
802.11 networking equipment, Data analysis, ERP, Human resource applications, Networking, Training, Wireless standards
I work at a large, urban university. We are looking to upgrade our whole IT infrastructure. We hired a consultant group and they feel it will take a quarter of a billion dollars to accomplish it. I want to find cheap, faster, better ways to upgrade. Also, I want to serve students, faculty and admin., [...]
Answer Question
| December 30, 2004 5:00 PM
802.11 networking equipment, Data analysis, ERP, Human resource applications, Networking, Training, Wireless standards
How to purge records from the database?
I am a newbie to database programming and have been given this project where data older than 7 days need to be removed from multiple tables that the application uses. I am thinking about creating a stored procedure to do that and schedule a job that will run this stored procedure everyday. Not sure if [...]
Answer Question
| December 21, 2004 4:42 PM
Database, DB2, Implementation, Oracle, SQL, SQL Server, T-SQL, Tech support
I am a newbie to database programming and have been given this project where data older than 7 days need to be removed from multiple tables that the application uses. I am thinking about creating a stored procedure to do that and schedule a job that will run this stored procedure everyday. Not sure if [...]
Answer Question
| December 21, 2004 4:42 PM
Database, DB2, Implementation, Oracle, SQL, SQL Server, T-SQL, Tech support
