Inserting and viewing of Chinese characters in DB2400
Dear All, We are trying to insert Chinese characters into an AS400 PF. We originally had the CCSID of the PF field as 13488, The job CCSID being 65535 HOWERVER when we are trying to input characters, it is taking as ????????? Later, we careated a new file – with CCSID 1200 and still the [...]
Answer Question
| May 5, 2011 5:35 PM
AS/400 DB2, CCSID, DB2, DB2 administration
Dear All, We are trying to insert Chinese characters into an AS400 PF. We originally had the CCSID of the PF field as 13488, The job CCSID being 65535 HOWERVER when we are trying to input characters, it is taking as ????????? Later, we careated a new file – with CCSID 1200 and still the [...]
Answer Question
| May 5, 2011 5:35 PM
AS/400 DB2, CCSID, DB2, DB2 administration
Contest Bounty: Earn 500 knowledge points!
You could earn 500 knowledge points for sharing your story. Simply read this blog post and then share your story of survival. If we publish your story, we will first ask permission and compensate you with 500 knowledge points to go toward our current IT Knowledge Exchange contest . Good luck!
Answer Question
| May 26, 2011 1:31 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Community, Knowledge Point Bounty, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
You could earn 500 knowledge points for sharing your story. Simply read this blog post and then share your story of survival. If we publish your story, we will first ask permission and compensate you with 500 knowledge points to go toward our current IT Knowledge Exchange contest . Good luck!
Answer Question
| May 26, 2011 1:31 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Community, Knowledge Point Bounty, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Spring Cleaning: Free IT Book(s) Giveaway!
This week’s IT book giveaway is a little bit different: 1. Answer two of the five questions listed below. Link to your answer in the discussion area of this question. 2. Ask five questions between May 2 and May 8. Link to your questions in the discussion area of this question. 3. Approve three answers [...]
Answer Question
| May 3, 2011 2:24 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
This week’s IT book giveaway is a little bit different: 1. Answer two of the five questions listed below. Link to your answer in the discussion area of this question. 2. Ask five questions between May 2 and May 8. Link to your questions in the discussion area of this question. 3. Approve three answers [...]
Answer Question
| May 3, 2011 2:24 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Visual Basic Login form and second form load
I am building an application that uses a username/passworm form for login and want to load from a flat file info relevant to the username entered in the login form. Will the code for the reading of the flat file go in the form_load of my second form this is the code I am trying [...]
Answer Question
| September 26, 2011 9:28 AM
Flat files, Visual Basic, Visual Studio, Visual Studio 2010, Windows 7
I am building an application that uses a username/passworm form for login and want to load from a flat file info relevant to the username entered in the login form. Will the code for the reading of the flat file go in the form_load of my second form this is the code I am trying [...]
Answer Question
| September 26, 2011 9:28 AM
Flat files, Visual Basic, Visual Studio, Visual Studio 2010, Windows 7
Unable to load Dynamic Link Library BASDB.DLL on Windows 7 Pro 64 bit
Windows 7 Professional – 64 bit Application is 32 bit application. Application uses Sybase 11 , and ODBC sources The DLL Basdb.Dll is located in the SYSWOW64 folder but is not loaded when called. Example of call to DLL. Alter Procedure “DBA”.”spbossaccountchg” ( in iaction integer, in iid integer ) external name ‘Bossaccountchg@Basdb.Dll’ *****Have added [...]
Answer Question
| May 2, 2011 1:54 PM
Sybase, Sybase Databases, User authentication, Windows 7 64-bit, Windows 7 Professional
Windows 7 Professional – 64 bit Application is 32 bit application. Application uses Sybase 11 , and ODBC sources The DLL Basdb.Dll is located in the SYSWOW64 folder but is not loaded when called. Example of call to DLL. Alter Procedure “DBA”.”spbossaccountchg” ( in iaction integer, in iid integer ) external name ‘Bossaccountchg@Basdb.Dll’ *****Have added [...]
Answer Question
| May 2, 2011 1:54 PM
Sybase, Sybase Databases, User authentication, Windows 7 64-bit, Windows 7 Professional
Finding a stream file CSV
i have a stream file in CSV format, we are not sure wheere this file is I have find out where this available in AS/400. I tryed wrklnk command and other options but i am not able to find this file. could you tell me the best way to find out this CSV stream file. [...]
Answer Question
| May 2, 2011 12:50 PM
AS/400, CSV, CSV format, Stream files
i have a stream file in CSV format, we are not sure wheere this file is I have find out where this available in AS/400. I tryed wrklnk command and other options but i am not able to find this file. could you tell me the best way to find out this CSV stream file. [...]
Answer Question
| May 2, 2011 12:50 PM
AS/400, CSV, CSV format, Stream files
Tell your friends about IT Knowledge Exchange, earn 100 points!
Tell your friends about IT Knowledge Exchange, and get 100 knowledge points closer to winning our latest contest. Simply send out this tweet to earn your points!
Answer Question
| May 27, 2011 7:55 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Contests, Knowledge Point Bounty, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
Tell your friends about IT Knowledge Exchange, and get 100 knowledge points closer to winning our latest contest. Simply send out this tweet to earn your points!
Answer Question
| May 27, 2011 7:55 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Contests, Knowledge Point Bounty, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
Domino Geo Clustering
Does anyone know or can anyone point me to docs on Domino Geo Clustering? More specifically, I’m trying to find out what the recommended (best practices) pipe would be between the two. I realize there are some x factors involved as well but I’m just looking for anything put out by IBM.
Answer Question
| May 3, 2011 7:38 PM
Clustering, Domino 8.5.2, Geo cluster, IBM
Does anyone know or can anyone point me to docs on Domino Geo Clustering? More specifically, I’m trying to find out what the recommended (best practices) pipe would be between the two. I realize there are some x factors involved as well but I’m just looking for anything put out by IBM.
Answer Question
| May 3, 2011 7:38 PM
Clustering, Domino 8.5.2, Geo cluster, IBM
Adding a MySQL user when no MySQL users have admin rights?
I’m working on a MySQL installation that has a user already created (“admin”), but that user doesn’t have a password, and doesn’t have any permissions, so I can’t create new users or even reset the password of that user. I’m using Ubuntu Server, and after looking through the help files I still can’t find a [...]
Answer Question
| April 28, 2011 6:33 PM
Database administration, MySQL, SQL, Ubuntu
I’m working on a MySQL installation that has a user already created (“admin”), but that user doesn’t have a password, and doesn’t have any permissions, so I can’t create new users or even reset the password of that user. I’m using Ubuntu Server, and after looking through the help files I still can’t find a [...]
Answer Question
| April 28, 2011 6:33 PM
Database administration, MySQL, SQL, Ubuntu
ODBC connection to the SQL server from the iSeries
Is there a way on the iSeries to establish an ODBC connection to the SQL server?
Answer Question
| May 5, 2011 6:14 PM
iSeries Access, ODBC, ODBC Permissions, SQL Server, SQL Server connectivity
Is there a way on the iSeries to establish an ODBC connection to the SQL server?
Answer Question
| May 5, 2011 6:14 PM
iSeries Access, ODBC, ODBC Permissions, SQL Server, SQL Server connectivity
Cloning my dual boot Ubuntu/Mac PC to another
HI, I have some computers which dual boots Ubuntu and Mac. I need to do the same in around 20 PC`s again !!! How can i do using less resources and time ?? (All PC`s are of the same configuration) (all computers can be connected via LAN) (I think Norton Ghost is not a solution [...]
Answer Question
| May 2, 2011 7:00 AM
Clone database, Dual Boot, Dual booting, LAN, Ubuntu, Ubuntu 10.04
HI, I have some computers which dual boots Ubuntu and Mac. I need to do the same in around 20 PC`s again !!! How can i do using less resources and time ?? (All PC`s are of the same configuration) (all computers can be connected via LAN) (I think Norton Ghost is not a solution [...]
Answer Question
| May 2, 2011 7:00 AM
Clone database, Dual Boot, Dual booting, LAN, Ubuntu, Ubuntu 10.04
Dynamic SQL query
Hi! I’m making an application in vb.net using MS Access as DB.. Nw in this, i want to do some complex stuff, that is dynamically making sql queries or in other words, changing the where clause according to user preference. The scenario let’s say is…in a form the user can search for records thru 1) [...]
Answer Question
| May 5, 2011 5:59 PM
Access Database, Dynamic SQL, SQL Query, VB.NET
Hi! I’m making an application in vb.net using MS Access as DB.. Nw in this, i want to do some complex stuff, that is dynamically making sql queries or in other words, changing the where clause according to user preference. The scenario let’s say is…in a form the user can search for records thru 1) [...]
Answer Question
| May 5, 2011 5:59 PM
Access Database, Dynamic SQL, SQL Query, VB.NET
Cloning existing database servers to migrate to virtual machine
Can we clone existing database servers with their contents and migrate to a virtual machine? We want to do this for two smaller database servers that are each on very expensive high level machines. One can be repurposed and the other can support both servers as vms.
Answer Question
| April 25, 2011 4:22 PM
Clone database, Database migration, Database servers, Virtual machine manager, Virtual Machines
Can we clone existing database servers with their contents and migrate to a virtual machine? We want to do this for two smaller database servers that are each on very expensive high level machines. One can be repurposed and the other can support both servers as vms.
Answer Question
| April 25, 2011 4:22 PM
Clone database, Database migration, Database servers, Virtual machine manager, Virtual Machines
10 Chances to Win $100
Starting today (April 25th) and running through May 31st, you have 10 chances to win a $100 Amazon.com gift card. The 10 IT Knowledge Exchange members with the most Knowledge Points earned between today and May 31st will win. Learn how to earn points in the Community Blog, or start answering questions and earning points.
Answer Question
| May 2, 2011 1:30 PM
Amazon.com, AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE Community, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Starting today (April 25th) and running through May 31st, you have 10 chances to win a $100 Amazon.com gift card. The 10 IT Knowledge Exchange members with the most Knowledge Points earned between today and May 31st will win. Learn how to earn points in the Community Blog, or start answering questions and earning points.
Answer Question
| May 2, 2011 1:30 PM
Amazon.com, AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE Community, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Back-up copies of the database
We have an access dbase that has multiple users for data entry. without fail, we end up with several “back-up” copies. Is this the result of the different users “saving” or is it from having shortcuts on their individual laptops?
Answer Question
| May 2, 2011 6:12 PM
Access Database, Database Backup, Database Backup Strategies
We have an access dbase that has multiple users for data entry. without fail, we end up with several “back-up” copies. Is this the result of the different users “saving” or is it from having shortcuts on their individual laptops?
Answer Question
| May 2, 2011 6:12 PM
Access Database, Database Backup, Database Backup Strategies
Receiving a Binary file
I have a vendor who is placing a files on a FTP Server in Binary. I need to retrieve those files and place them into an iSeries database file. Is there away to retrieve the file straight from the FTP Server into the database file using GET that will translate from binary to mixed text [...]
Answer Question
| May 3, 2011 2:32 PM
Binary data, Database Files, FTP, iSeries, RPG IV
I have a vendor who is placing a files on a FTP Server in Binary. I need to retrieve those files and place them into an iSeries database file. Is there away to retrieve the file straight from the FTP Server into the database file using GET that will translate from binary to mixed text [...]
Answer Question
| May 3, 2011 2:32 PM
Binary data, Database Files, FTP, iSeries, RPG IV
Link SQL Server 2008 to AS400
How to set up a ODBC for SQL 2008 to the AS400
Answer Question
| August 10, 2011 11:49 PM
AS/400 SQL, ODBC, SQL 2008, SQL Server 2008
How to set up a ODBC for SQL 2008 to the AS400
Answer Question
| August 10, 2011 11:49 PM
AS/400 SQL, ODBC, SQL 2008, SQL Server 2008
Free IT Book: Why New Systems Fail
This week’s free IT book is Phil Simon’s insider’s guide to successful IT projects, Why New Systems Fail. From the back of the book, “Organizations often lack the necessary framework to minimize the chance of system failure before, during, and after beginning IT projects.” Get the know-how you need to start and successfully deploy your [...]
Answer Question
| February 23, 2012 3:46 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
This week’s free IT book is Phil Simon’s insider’s guide to successful IT projects, Why New Systems Fail. From the back of the book, “Organizations often lack the necessary framework to minimize the chance of system failure before, during, and after beginning IT projects.” Get the know-how you need to start and successfully deploy your [...]
Answer Question
| February 23, 2012 3:46 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Career Advise DW & BI background + MBA
Hi, I have a 5 years of expericence as ETL Developer in Informatica. I want to get an MBA degree. Before investing my time, efforts and money, I would like to know: 1. what are the benefits of getting an MBA with DW&BI exp? 2. what is the designation or salary growth in short (ROI) [...]
Answer Question
| March 6, 2012 10:38 PM
Data warehousing, ETL, IT careers, IT certification, IT certification and training
Hi, I have a 5 years of expericence as ETL Developer in Informatica. I want to get an MBA degree. Before investing my time, efforts and money, I would like to know: 1. what are the benefits of getting an MBA with DW&BI exp? 2. what is the designation or salary growth in short (ROI) [...]
Answer Question
| March 6, 2012 10:38 PM
Data warehousing, ETL, IT careers, IT certification, IT certification and training
Data Center certification
Hi, I am an ITIL and PMP certified professional looking for Data centre certification by which I can add value in Data Center project. What would be your suggestion (expense , duration and help to go ahead in my career) ? Thanks in advance Regds Rajesh Teraiya
Answer Question
| May 3, 2011 3:27 PM
Data Center, Data Center administration, Data center certification, IT careers, IT certification, ITIL, ITIL Certification, PMP
Hi, I am an ITIL and PMP certified professional looking for Data centre certification by which I can add value in Data Center project. What would be your suggestion (expense , duration and help to go ahead in my career) ? Thanks in advance Regds Rajesh Teraiya
Answer Question
| May 3, 2011 3:27 PM
Data Center, Data Center administration, Data center certification, IT careers, IT certification, ITIL, ITIL Certification, PMP
