 | |
AS400 & filter by date
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
AS400 & filter by date -
03-31-2008
, 09:33 AM
#2
| |||
| |||
|
|
Hello, we need to import data from AS400 to MS SQL 2000 via ODBC driver (iSeries ODBC by IBM). The trouble is with date format and using functions such as NOW() or GETDATE(). Using these function results in errors, because the ODBC driver doesn't support these commands. But we need to upload data filtered by actual date. AS400 date field is in fact a number. So, the task is to compare (or filter in WHERE clause) number (AS400) with system date (MS SQL) Thanks for any help, Tomas |
CURRENT_DATE which you would then have to convert to the number format that
you can compare to your number field.
#3
| |||
| |||
|
|
Hello, we need to import data from AS400 to MS SQL 2000 via ODBC driver (iSeries ODBC by IBM). The trouble is with date format and using functions such as NOW() or GETDATE(). Using these function results in errors, because the ODBC driver doesn't support these commands. But we need to upload data filtered by actual date. AS400 date field is in fact a number. So, the task is to compare (or filter in WHERE clause) number (AS400) with system date (MS SQL) Thanks for any help, Tomas |
CURRENT_DATE which you would then have to convert to the number format that
you can compare to your number field.
#4
| |||
| |||
|
|
Hello, we need to import data from AS400 to MS SQL 2000 via ODBC driver (iSeries ODBC by IBM). The trouble is with date format and using functions such as NOW() or GETDATE(). Using these function results in errors, because the ODBC driver doesn't support these commands. But we need to upload data filtered by actual date. AS400 date field is in fact a number. So, the task is to compare (or filter in WHERE clause) number (AS400) with system date (MS SQL) Thanks for any help, Tomas |
CURRENT_DATE which you would then have to convert to the number format that
you can compare to your number field.
#5
| |||
| |||
|
|
Hello, we need to import data from AS400 to MS SQL 2000 via ODBC driver (iSeries ODBC by IBM). The trouble is with date format and using functions such as NOW() or GETDATE(). Using these function results in errors, because the ODBC driver doesn't support these commands. But we need to upload data filtered by actual date. AS400 date field is in fact a number. So, the task is to compare (or filter in WHERE clause) number (AS400) with system date (MS SQL) Thanks for any help, Tomas |
CURRENT_DATE which you would then have to convert to the number format that
you can compare to your number field.
#6
| |||
| |||
|
|
Hello, we need to import data from AS400 to MS SQL 2000 via ODBC driver (iSeries ODBC by IBM). The trouble is with date format and using functions such as NOW() or GETDATE(). Using these function results in errors, because the ODBC driver doesn't support these commands. But we need to upload data filtered by actual date. AS400 date field is in fact a number. So, the task is to compare (or filter in WHERE clause) number (AS400) with system date (MS SQL) Thanks for any help, Tomas |
CURRENT_DATE which you would then have to convert to the number format that
you can compare to your number field.
#7
| |||
| |||
|
|
Hello, we need to import data from AS400 to MS SQL 2000 via ODBC driver (iSeries ODBC by IBM). The trouble is with date format and using functions such as NOW() or GETDATE(). Using these function results in errors, because the ODBC driver doesn't support these commands. But we need to upload data filtered by actual date. AS400 date field is in fact a number. So, the task is to compare (or filter in WHERE clause) number (AS400) with system date (MS SQL) Thanks for any help, Tomas |
CURRENT_DATE which you would then have to convert to the number format that
you can compare to your number field.
#8
| |||
| |||
|
|
Hello, we need to import data from AS400 to MS SQL 2000 via ODBC driver (iSeries ODBC by IBM). The trouble is with date format and using functions such as NOW() or GETDATE(). Using these function results in errors, because the ODBC driver doesn't support these commands. But we need to upload data filtered by actual date. AS400 date field is in fact a number. So, the task is to compare (or filter in WHERE clause) number (AS400) with system date (MS SQL) Thanks for any help, Tomas |
CURRENT_DATE which you would then have to convert to the number format that
you can compare to your number field.
#9
| |||
| |||
|
|
Hello, we need to import data from AS400 to MS SQL 2000 via ODBC driver (iSeries ODBC by IBM). The trouble is with date format and using functions such as NOW() or GETDATE(). Using these function results in errors, because the ODBC driver doesn't support these commands. But we need to upload data filtered by actual date. AS400 date field is in fact a number. So, the task is to compare (or filter in WHERE clause) number (AS400) with system date (MS SQL) Thanks for any help, Tomas |
CURRENT_DATE which you would then have to convert to the number format that
you can compare to your number field.
#10
| |||
| |||
|
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.