Hi all
I got the answer , we need to edit the particular user's .Profile file. by adding the information as
*************** *************** *************** ********
if [ -f /home/db2inst1/sqllib/db2profile ]; then
. /home/db2inst1/sqllib/db2profile
fi
*************** *************** *************** **********
Thanks
User Profile
Collapse
-
To Execute DB2 commands on AIX with a user other than instance.
I recently installed DB2 and created users and one instance ID on an AIX Server machine. I am able to execute DB2 commands if i login with instance ID alone but not with the other users. I came to know that i need to edit some profile file . Can somebody tell me what needs to be edited -
-
DASCRT Command failed.
--------------------------------------------------------------------------------
I am setting up new server on AIX. I initally installed V8.1.1.64 , After which i installed Fixpack to upgrade it to DB2 V 8.1.1.82 , in which i have instance folder and i am able to see dascrt and db2icrt files and... etc (total of 30) files. But when i issue the command
*************** *****
# dascrt -u dasusr1
ksh: dascrt: not found.... -
Equivalent DB2 Datataypes comapred to PostgreSQL
Hi
Can anyone help me in knowing the equivalent Datatypes in DB2 for BYTEA, TEXT datatypes in PostGreSQL
and
Can I Create a ROLE in DB2 with a validity as in PostgreSQL
Here is the CREATE role syntax in PostGreSQL
CREATE ROLE XX LOGIN PASSWORD 'xxx'
NOINHERIT CREATEDB CREATEROLE
VALID UNTIL 'infinity';
Reply With Quote -
IBM DB2 ODBC Driver
Can someone please tell me from where i can download the IBM Db2 ODBC Driver . I am trying to connect to DB2 Database using the ODBC Driver. -
To Connecto UDB Db2 Database through .NET Application
Hi
I would like to know how to connect to UDB DB2 Database ( 9.1 Version) through .NET Application.
Please let me know what is the dll that needs to be referenced in my .NET application so as to connect to the DB2.
any sample examples will be helpful
Thanks -
-
Saving Document in DB through .NET application
Hi
I want to save a document in PostgresQl DB ( I defined the table with two columns as Documentname and document ). And i wrote a .net application for attaching the document to save it in the DB .
I connected to the DB
used the openfile dialouge and opened the document and said open.
Documentname is populated.
but not getting any idea how to save the document in the DB. Pls help me... -
robintwos replied to How to Validate the Data while entering Data into textbox only for numeric valuesin .NETThanks for the replies . I solved it my self . I publish my questions here as i started learning .NET newly. Sorry if you people think , i am asking very much basic doubts. I'm learning it on my own. i dont know much in VB.NET.Leave a comment:
-
robintwos replied to How to Validate the Data while entering Data into textbox only for numeric valuesin .NETHi Thanks for ur code .. I can enter "." also . so i modified the code to allow "." But now i am able to enter "." multiple times .. its an amount field and "." should be entered only once.Leave a comment:
-
robintwos started a topic How to Validate the Data while entering Data into textbox only for numeric valuesin .NETHow to Validate the Data while entering Data into textbox only for numeric values
Hi
I would like to validate the while entering the data in a textbox for numeric values.
it means . i would like to throw an error message when the user enters a character value. validation should happen while entering it self .
I am looking for the piece of code in VB.NET. Please do help me
Thanks -
Hi .. Thanks alot ... I need to install it .as soon as possible please help me outLeave a comment:
-
Can u please provide me the link for downloading VB6 version on Vista Business . I too have vista Business only.Leave a comment:
-
Is it ok to install both VB6 and Visual Studio 2005 on Vista?
I have Visual Studio 2005 installed on my Vista machine. Due to some requirement i want to install VB 6 now. Can i install it now ?
If Yes please provide me the link to download the same.
fast reply is appreciated
Thanks -
Table Creation Problem
How to Declare a Column which needs to be incremented by 1 in postgreSQL
in DB2 we use COL1 INTEGER AS IDENTITY, -
VB.NET : Enumaerating all hostnames in the network
How we can enumerate all host names which are connected to a single network in vb.net? -
VARCHAR field memory storage
A field declared as VARCHAR(10) , how many bytes of data it can occupy ?
and
can i move a field which is declared as VARCHAR(10) to CHAR(10).? -
Connecting to PostgreSQL using VB.NET
How do i connect to PostgreSQL tables from a .net Application -
I could create the TS in postgres user. But i was trying to create another TS outside postgres user. which is failing.
I believe i can't create TS in another user . But still was trying to confirm
This was the SQL i used to create TS in postgres
CREATE TABLESPACE "SampleTS"
OWNER postgres
LOCATION 'C:/Documents and Settings/postgres/SampleTS';
And to create TS...Leave a comment:
No activity results to display
Show More
Leave a comment: