Database

Re: Convert in Informix SQL

18-Jan-08 5:43

its a pleasure Smile | :)

Sathy

Convert in Informix SQL

Bad Programmer17-Jan-08 13:53

Bad Programmer

17-Jan-08 13:53

Hi All,

Here's the Query from SQL 2000:

Select * from table1 <br />
  Where Convert(DateTime,dtStTime,103) > = '17/01/2008'<br />
  And Convert(DateTime,dtStTime,103)  <= '19/01/2008'

????I want to have same kind of functionality query for Informix between ranges............

Please help as im new to Informix and im in midway of my project...

Bala

John_Adams17-Jan-08 22:21

John_Adams

17-Jan-08 22:21

Hi,

Please try the following query:

SELECT * from Table1
WHERE DATE(dtstTime) > = '17/01/2008'
And DATE(dtstTime)<= '19/01/2008'

For more information on Informix SQL please visit the following web links:

http://www.dbcenter.cise.ufl.edu/triggerman/infoshelf/sqlt/02.toc.html#540217

http://www.dbcenter.cise.ufl.edu/triggerman/infoshelf/sqlt/02.fm2.html#104594

I hope this helps.

Regards,
John Adams
ComponentOne LLC

Re: Convert in Informix SQL

andyharman17-Jan-08 23:09

andyharman

17-Jan-08 23:09

Hi Bala

I haven't used Informix for a long time, but you should be able to use:

Select * from table1 <br />
Where dtStTime between '17/01/2008' and '19/01/2008'

Informix uses environmental variables to determine the date format. From memory, DBDATE should be set to "DMY4/" for your example.

Regards
Andy

Table

simworld17-Jan-08 8:08

simworld

17-Jan-08 8:08

How to get the column name/Field name from a particular Table.
I want to list them in dropdownlist in C#

pmarfleet17-Jan-08 8:20

17-Jan-08 8:20

Ever heard of Google[^]?

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Paul Conrad17-Jan-08 13:36

Paul Conrad

17-Jan-08 13:36

You need to provide more detail. What kind of database are you using?

"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon

simworld18-Jan-08 0:36

simworld

18-Jan-08 0:36

I am using SQL Server 2000.

Paul Conrad19-Jan-08 7:00

Paul Conrad

19-Jan-08 7:00

I think you can get table characteristics by looking in the system tables. Don't quite have the info right infront of me at the moment.

---modified

Never mind, imsathy got it Big Grin | :-D

"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon

imsathy17-Jan-08 18:01

17-Jan-08 18:01

SELECT <br />
TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH<br />
FROM  INFORMATION_SCHEMA.COLUMNS<br />
WHERE TABLE_NAME = 'your table name'

Sathy

simworld18-Jan-08 0:39

simworld

18-Jan-08 0:39

Thank u very much

imsathy18-Jan-08 5:45

Importing a PDF Document into SQL Server

18-Jan-08 5:45

Its a pleasure Smile | :)

Sathy

Makhangs32f17-Jan-08 7:17

Makhangs32f

17-Jan-08 7:17

Hi All,

We have a PDF document about 2MB.It has many web links.

We are trying to get this document into a database format with search & reporting capabilities and we want to preserve all links and text formats in the document.

We have a couple of questions:

- What database technology could we use that could run on both a CD and a web site?
- What conversion tools (and processes) would be best to use to import the content into a database?
-Can SQL Server 2000 Reporting Services help us? If so,how?

Any help/suggestions will be appreciated.Thanks.

Paul Conrad17-Jan-08 13:37

Paul Conrad

17-Jan-08 13:37

Good luck is all I can pretty much say right now Smile | :)

"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon

pmarfleet18-Jan-08 2:47

18-Jan-08 2:47

Makhangs32f wrote:

We have a PDF document about 2MB.It has many web links.

2MB isn't very big. I think it would be easier to migrate the content by hand rather that trying to do it programmatically.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Makhangs32f18-Jan-08 3:11

Makhangs32f

18-Jan-08 3:11

Hi Paul,

Thanks for your reply.

To migrate the content,here is our initial plan:

-Convert PDF into a word or text file.
-Use SQL loader to transfer the content to the database.

We appreciate your comments on this plan.Also please feel free to suggest any other way to migrate the content to a database.

pmarfleet18-Jan-08 6:33

18-Jan-08 6:33

Makhangs32f wrote:
Also please feel free to suggest any other way to migrate the content to a database.

Not knowing anything about the structure of your data, I can't really help.

The content of a PDF file is likely to be unstructured. This means it would be difficult to write scripts to load data into a structured repository like a database. Your best bet is to cut and paste the content into Excel or a text file and load the data from there.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Makhangs32f21-Jan-08 2:38

Makhangs32f

21-Jan-08 2:38

Hi Paul,

Thanks for your suggestions regarding loading the PDF into a database.

We have one more thing where we need your suggestion.

We need to publish the database in some format (e.g., XML, MySQL, etc.) to a CD-ROM or DVD.Please let us know if you know some way to do it.Or if you can post a couple of URLs that we can look at to get some ideas on it,that will be helpful too.

Thanks.

pmarfleet21-Jan-08 9:14

ADD auto Increment column

21-Jan-08 9:14

If you are using SQL Server 2005, you should consider using SQL Server Integration Services (SSIS) to produce your exports. This site[^] has plenty of useful information. I suggest you search it for information on exporting data to specific formats. Deciding what format to export your data depends largely on the requirements of the people who will be consuming the data. Have you discussed this with your users, and what have they told you?

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

mpavas17-Jan-08 2:37

mpavas

17-Jan-08 2:37

Hello,

I have datatable and it is populated with some values.
Is it possible to add a column in an exiting datatable now with a auto increment values?

I am trying like this but it does'nt wotk

dslistItems1.Tables[0].Columns.Add("ID", Type.GetType("System.Int32"));
DataColumn[] pk = new DataColumn[1];
pk[0] = dslistItems1.Tables[0].Columns["ID"];
//dslistItems1.Tables[0].PrimaryKey = pk;
dslistItems1.Tables[0].Columns["ID"].AutoIncrement = true;
dslistItems1.Tables[0].Columns["ID"].AutoIncrementSeed = 1;
dslistItems1.Tables[0].Columns["ID"].ReadOnly = true;

This code doesn't populate the values in the column

Regards,
Pavas

Re: ADD auto Increment column

imsathy17-Jan-08 19:26