Dear AS/400 Lovers! I need to convert a string containing Numeric-value with two-decimal places into a “Numeric”. Alternatively the string may contain a minus-sign(‘-’) in the beginning of the numeric-string(e.g. ‘-4321007.86′). The result should be pure numeric i.e. -4321007.86 The string’s total length is 11-char, including minus-sign(‘-’) & decimals. I tried using %TRIM and then [...]
Answer Question | July 5, 2010 2:51 PM
AS/400, OS/400, RPGILE, String manipulation
for some reason the first time I posted this it only showd some of it, so I’ve reposted it. I would like to know the code to do a “if file exist then” in visual basic. something like in a .bat file as follows. IF EXIST C:install.log ( @echo I’m here ) ELSE ( @echo [...]
Answer Question | July 1, 2010 6:18 AM
.bat file, Visual Basic, Visual Basic developers, Visual Basic Functions
Transferring files mainframe to mainframe via NDM and suddenly getting: Submitted DSN=> No DSN available: DSN Offset=0.
Answer Question | June 30, 2010 4:18 PM
Mainframe, NDM, Network Data Mover, Syntax errors
Today’s live chat from 1-3 pm EST provides an exclusive opportunity to get your cloud migration questions answered directly from industry experts. Get tips on how to improve your ability to recover in any type of loss or disaster while keeping your budget in check and gain insight into: Data protection requirements Cloud vs on-premises [...]
Answer Question | July 8, 2010 2:18 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, datamangement, Developement, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
How can I write a SQL query to get the DB name ? Usually we use SELECT DB_NAME() AS DataBaseName, but at that time teh DB is in use. If we didn;t write use [dbname][/dbname], is there any way to get the DB name ?
Answer Question | June 30, 2010 11:35 AM
Database name, SQL 2008, SQL Database, SQL Query
I have a column whose values range from 10-15 characters and whose last 7 characters I would like to get rid of. Can someone please show me how to do this? I thought it would be RTRIM but that didn’t work for me. I can’t use LEFT or RIGHT before the column because the column [...]
Answer Question | June 29, 2010 6:40 PM
RTRIM, SQL Server Express 2005, SQL Server Functions, TRIM function
I want to find fields that may be the same in some parts but not 100% identical For example Field 1 Has the word “Smith” Field 2 has “Smith AB” in it Is there any code i can write to find these, without writing code for every single name I am using SQL server 2008 [...]
Answer Question | July 14, 2010 3:37 PM
SQL commands, SQL Fields, SQL Server 2008 administration, SQL Server development
I have the following piece of code attached to my Excel worksheet: ActiveSheet.Shapes(“Object 407″).Select Selection.Copy Range(“BP106″).Select ActiveSheet.Paste The code is activated by making a choice in a drop down in the worksheet. The worksheet is password protected but the cell BP106 is not locked. When I make a selection from the [...]
Answer Question | June 28, 2010 3:18 PM
Excel 2007, Excel VBA, VBA, Visual Basic for Applications
how can insert values in array throw Scanner class or wrapper class?
Answer Question | June 28, 2010 7:21 AM
Array Configuration Tool, Java scanner class, JDK 1.5, Storage in 2010
I want to download (dev-c++4).Two days long search bring no fruit.Help me.
Answer Question | August 28, 2011 3:29 AM
Compilers, Debugger, Open source software, Program Debugging, Programming Language
I have a carrier table and a product table. The Carrier table i have CarrierID and Carrier Name. In the Product Table I have ProdID,Carrier, and Product name. What I want to accomplish on a form is when I select a carrier in a combo window and then select Product in another window , I [...]
Answer Question | June 24, 2010 5:17 PM
Access 2003, Access 2003 forms, Access Datasheet, Access Tables, Microsoft Access ComboBox
I have a program that requires a user to input his/her IDNumber. If it doesnt exist the program will prompt to go to the NewRecord section. When the user input his IDNumber and he will be logged on to the real program. After doing the program and pressing the DONE Button. A messagebox will appear [...]
Answer Question | August 3, 2010 2:36 PM
C#, Programming, SQL 2005, sql 2005 Performance Issues, SQL Database
What is the difference between front-end and back-end development? I am referring to the development of a consumer-facing website. Some of the main technologies used are Java and PHP. I’m not that technical so I am looking for an answer that’s easy to understand. Thanks!!
Answer Question | April 17, 2013 2:09 PM
Java development, Linux development, Web development tools
For example on an as/400 Data base file, some 10 indexes are created? How would we know which index is been used during Native IO reads or SQL query execution happens on that file during program is being run?
Answer Question | June 25, 2010 10:53 AM
AS/400 database, AS/400 DB2, SQL Query
I use a form to hold the details of a client. The form has a subform [datasheet] which details each visit that the client makes. To do an invoice for the visit I have a pop-up form. I would like information from that pop-up form to be transferred to the datasheet subform. How can I [...]
Answer Question | June 24, 2010 8:46 AM
Access Datasheet, Access forms, Microsoft Access subforms, Visual Basic Data Report
Has anyone seen a weird behavior when a database has been open for an extended amount of time and when you finish fillling out a form and click save a message appears stating Frameset *** does not exist? I have multiple databases that this is happening in and want to know why. It’s almost like [...]
Answer Question | June 24, 2010 12:15 AM
Frameset, Lotus Domino Server 8.x, Lotus Notes 8.5.1, Lotus Notes 8.x, Lotus Workflow
I need to know if the numbers after a decimal point are greater than 0. What is the easiest SQL syntax to do this?
Answer Question | June 24, 2010 8:42 PM
SQL, SQL Query, SQL Syntax
Hello, i am working with vs2008 (web application) and I want to copy some content from an excel sheet and and using the clipboard i want to copy the contents in a gridview I have tried using Clipboard.GetDataObject() but no matter what ever i do it is always returning null so can anyone suggest me [...]
Answer Question | June 23, 2010 2:37 PM
ASP.NET, excel, GridView, Microsoft Visual Studio, Visual Studio 2008
The period provided is invalid. It is either not found in the user period, is prior to the cutoff date/resource start date, or is after the resource termination date.
Answer Question | June 23, 2010 1:59 PM
PlanView, PlanView 7.4.1, Portfolio Management, Project Management Software, Software process models
What is the good way of mapping multipart external Identifiers(which is different for different external parties) to an internal Identifier. for example suppose we have two parties whose identifiers to represent their single product is different. party1 – ID set (p11, p12, p13) party2 – Id set (p21,p22) and we need to map these external [...]
Answer Question | June 23, 2010 11:57 AM
Data conversion, Mapping, String manipulation