• Connect to Unix from iSeries

    I am trying to connect to EDW data mart on a Unix server from an SQLRPGLE pgm using the embedded SQL CONNECT TO code. I am getting SQLCOD = -000000113 when in debug and the connection fails. I have the code I can send in an email if you want? BCL2008

    BCL20085 pointsBadges:
  • High values from EBCDIC to ASCII not converting correctly

    WHEN CONVERTING AN EBCDIC FILE WITH HIGH-VALUES(X'FF' CAPITAL 'Y' WITH 2 DOTS OVER IT) TO ASCII HIGH-VALUES, MICROFOCUS IS RETURNING X('9F', CAPITAL 'Y' WITH 2 DOTS OVER IT), NOT X('FF', LOWER CASE 'y' WITH 2 DOTS OVER IT) IN THE ASCII FILE, THEY ARE CONVERING/MATCHING TO THE EBCDIC AND ASCII...

    THOPPER20 pointsBadges:
  • Are parameters permitted on SQL Server 2000 views

    I think the answer to this is NO, but is there a way to create a view that accepts input parameters? I created the view hard coding in something that now needs the flexibility that a parameter would provide, but I've never seen a parameter on a view - Is it possible? Thanks

    CO Bill120 pointsBadges:
  • Subquery in Microsoft Access

    [em]   Trying to create a subquery for a table in Access.   I am trying to pull out of a table all records where Sales amount is greater than 1000 and the discount rate is less than 5%. I have to calcuate the discount percentage in the  table, and don't want to create another table with that...

    Miltonfung5 pointsBadges:
  • problem with running oracle 10g form builder

    dear all, I am having a problem with running oracle 10g form, I am running windows xp s2 ,oracle database 10g R2 and oracledeveloper suite 10g. I installed Jinitaitor,and all required java programs that are required as I know. the case here,when I run the form my browser show white page ! no errors...

    Ddeveloper75 pointsBadges:
  • iSeries Navigator SQL Script Output

    I'm not familiar with CL but is there an easy way to direct the output of an adhoc SQL query in iSeries Navigator into a CSV file in my local Windows drive? Thanks in advance.

    Jaggerdude60 pointsBadges:
  • Using a combobox to control textbox

    how do I code this?

    Wstring0115 pointsBadges:
  • RPG/400 number of Records present in a physical file using file information data structure

    FPF001   IP  E                    DISK                        F                                              KINFDS INFDS1  IINFDS1      DS                                               I                        ...

    Kaly470 pointsBadges:
  • What does this mean when SQLCOD = -206? I need to write 2 sets embedded SQL statement in my program.

    what does this mean when SQLCOD = -206. I need to write 2 sets embedded SQL statement in my program. first one is one and I was able to fetch data but the 2nd one has error just right after I declare cursor. Here are the statements EVAL SQLSTMT2 = SELECT_H_2 + WHERE_H_2; + AND_H_A; EXEC SQL PREPARE...

    Huana5 pointsBadges:
  • How to manual configure tomcat with crystal reports 11

    How to manual configure tomcat with crystal reports 11

    Deepanshu0035 pointsBadges:
  • THREADSAFE parameter on DSPCMD STRSQL

    Can i get the help on this parameter whose values are *YES and *NO. The value is currently *NO, when should and how can i change it to *YES. Will this improve the performance of my SQL procedures?

    JohnsonMumbai1,160 pointsBadges:
  • Create SQL statement in VBA Access 2007

    How can I create a select Group BY SQL statement inside a VBA module? I've ran actions queries and they seem to take an effect in my tables but I'm having a difficult time creating a Select statement. Please display a couple of samples

    Bostic8620 pointsBadges:
  • Best practices involving admin rights for user on user system

    We are currently in the middle of figuring out the approach we are going to take in regard to a user having admin rights on their system. Typcially we set up a new user as an administrator on their system when they are logged into the domain. They don't have a local admin account on the system,...

    Kevins740 pointsBadges:
  • ASP Web page database?

    I want to do a web page with ASP.NET I already make another one using Access as my database manager but now is a bigger project so I want to know what can I use for create the database or if it's good still with access. (I Know basically  "everything" is SQL but please give me a good...

    Eddy20 pointsBadges:
  • User Interface of windows 7

    how to upgrade/improve the user interface of Windows 7? Any specific tools for windows desktop?

    Jawad1234567830 pointsBadges:
  • Crystal report XI passsing value help?

    hi! i have a problem with passing values in crystal report from my application (delphi). what i need to know is how to pass a variable that has a data to crystal report. any help would be appreciated Regards, Happy

    Hapipee15 pointsBadges:
  • uploading a excel file to ifs file on as400

    Is there a way to upload a excel spreadsheet up to qdls as a ifs file?

    Lnspgm15 pointsBadges:
  • Data Changing when closing an Access 2003 form

    I have a form in Acess2003 with a subform, the subform is linked on two fields, name and date. If I close the form when my master form is on the first name in the combox everything works fine - If I close the form not on the first name in the combo box, then whatever name it is on gets the date of...

    Nainey455 pointsBadges:
  • Visual FoxPro 6.0 troubles exporting large files to excel

    I have large databases that need to be sent to customers in a manifest.  So i export it from FoxPro six to excel 5.0 and save it in my documents then attach it to an e-mail. The trouble i am having is exporting a large database.  FoxPro does not export the whole thing when i export it. It stops...

    0 pointsBadges:
  • Exporting large files from FoxPro 6.0 to excel

    I asked about exporting large files from fox pro 6.0 to excel because my computer was cutting off large data base i am trying to export. This is the answer you gave me: Excel is stopping at 16k records.  As a workaround, export to CSV format; you can then use a text editor (e.g., Wordpad) to split...

    0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following