Hi all!
I must select from sources only new records. In my source I have timestamps (MSSQL server binary8 timestamps). I'm using job parameter telling me what is the last number of previously loaded record and in transformer I'm rejecting old ones.
I'm wondering - is there some way to use this jobparmeter in ODBC stage to select there only new records??
Or is there another way to take from source only new records when we hav e timestamping in database and information (i.e. from file) what was the last row number previously loaded??
select only new records (ODBC stage)
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can use job parameters for constants in the WHERE clause of the SELECT statement.
Fill in the WHERE clause, without the word WHERE, on the Selection tab of the ODBC stage Output links properties.
Fill in the WHERE clause, without the word WHERE, on the Selection tab of the ODBC stage Output links properties.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
OK ray, but how (in what form) must I write job parameter ??You can use job parameters for constants in the WHERE clause of the SELECT statement.
Fill in the WHERE clause, without the word WHERE, on the Selection tab of the ODBC stage Output links properties.
for example : I have parameter xxx - what is the proper form for ODBC stage WHERE clause window ??
LUK
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom