DSXchange

I'm doing a proof of concept on reading and writing to excel spreadsheets. I've created a spreadsheet with half a dozen rows and columns. I've created an ODBC connection and can read and write to the spreadsheet. BUT ! I put an @SUM calculated field on the end of the rows that totals them up. If I u...

I've just added the job to the schedule then looked at the schedule details as you suggest :- Job Schedule Detail Project BI_Layer(gal04019) Job name REMOVE_FROM_DATE Schedule #: 433 Run time: 17:00 Occurrences: 1 Run date: Today Job parameters: parmSourceUserId=ds_account parmSourcePassword=LL9@9HV...

parmDateTime is a job parameter and while I'm trying to solve this problem it has a default value of 2006-02-03 23:59:59 (no quotes).

This is the Log Info from when the job has been kicked off by the scheduler :- Starting Job REMOVE_FROM_DATE. parmSourceUserId = ds_account parmSourcePassword = ******** parmDestinationSource = dcsr1 parmDestinationUserId = ds_account parmDestinationPassword = ******** parmDateTime = "2006-02-0...

This is the Before-Stage command :- DELETE from CONSORT_AUDITS WHERE DATE_ADDED > TO_DATE('#parmDateTime#','YYYY-MM-DD HH24:MI:SS') I don't know where the double quotes are coming from. As I say when I run in real time it work fine but when I schedule the job and log off, datastage adds the double q...

I am trying to schedule a job which is reading back from a production Oracle Database to a development environment (still Oracle), but I do not want any data that is added after a certain date. So after I have bulk copied the data I delete what I don't need using a before SQL command in an Oracle st...

ArndW,

Many thanks I followed your advice and located the routine.
It looks like the developer had commented out most of his/her PRINT statements but had missed one.

Thanks again,
Ian

Hi ArndW,

Yes I'm definately running version 7.5.

As to whether it's a PRINT or DSLogWarn command that is generating the warning I don't know. That's my problem, I can't locate the routine (assuming it is a routine) that is generating the "Sat to Sun no time" message.

Regards,
Ian

I've picked up a job written by another datastage developer which is generating a phantom error message :- Project: BI_Layer Host system: xxxx Items: 1 - 12 Sorted on: Date Sorter Occurred: 10:03:52 On date: 30/01/2006 Type: Control Event: Starting Job DIST_EXPORTPIPELINE_ian_debug. (...) Occurred: ...

Thanks Ray.
I did use the pivot stage in the end although it was a tedious way round, having to split the data out into columns first then combining them back together again.
Leaves me wondering what the point of the row splitter stage is though ?

I've found topics on rowsplitter but they don't give me an answer to my particuler problem. I have an Oracle table that contains columns :- Orderref varchar(6) Status varchar(2) Submission_Tstamp Timetamp (19) Order_Data varchar(2040) Order_Data contains information about options the customer select...

How can I get the Date and Time Attributes of a Windows file ?

Thanks Michael,

I have also been able to get this approach working as well.

Regards,
Ian

Thank you mleroux.
Tried your code and it worked perfectly.
Have yet to see how it copes with files that are 7 million rows large !

Regards,
Ianm

I am fairly new to datastage and I'm trying to get the logic of hashfile look ups. I have set up a couple of test hash files :- TEST_hashfile Field 1 (Key) Field2 Field3 row1 test1 test1 row2 test2 test2 row3 test3 test3 TEST_feed_hashfile Field 1 (Key) Field2 Field3 row1 test1 test1 row2 change tes...