DSXchange

If I only want to update the last_updated_on and last_updated_by columns if any ONE of 6 other columns are actually updated during an update to an Oracle table, how can I accomplish this? Do I have to use a separate transform for every column? Right now, I'm doing an insert and an update into this t...

Is this valid syntax for a reject constraint, for example if you're checking whether to insert a record into a table - first to check to see if the record already exists so the insert will occur, then to check to make sure a value is = 'Y' and not 'N', then to check to make sure a value is not equal...

I'm still having trouble getting a match, but I'm going to play around with the SQL statements (outside of DS) to see what works, unless someone else has a suggestions (I've tried trim and upcase already). For the next process I have to perform (once I'm able to get the employee either inserted or u...

I put the TRIM(UPCASE(from_link.EMPLOYEE_NUMBER) etc. in my hash file and the hash file was created again (the data in the view that the hash file is created from is already uppercase anyway) then in the transform where I'm using the hash file to insert or update - on the insert fields I put the tri...

I tried the trim, didn't work, so I'll try case-sensitive.

By the way, I had populated the Oracle employee table with data and there are 821 rows - that's why the number in monitor for rows.

The Monitor shows 821 rows from EP_TABLE (my Oracle employee table) and 821 rows to my sequential files (why 821 and not 3 I don't know). However there are 0 rows from the employee hash file. Regarding spaces: the hash file and the Oracle employee table both define EMPLOYEE_NUM as varchar(10), FIRST...

Sorry, that last sentence wasn't complete - The columns in the sequential file are linked to the columns in the employee_hash_file and written to the sequential file. If I can see the data when I click the View Data button on the hash file why is it not being written to the sequential file if there ...

Good idea - I added a link from the same transform to a sequential file with the same columns. The file was created and the data I had defaulted in (e.g. creating the employee id with a sequential#, adding the date created) is there, but my other data columns (employee_number, first_name, last_name,...

Thanks to you both for your responses. I really want to succeed at this and admire you both for your knowledge and thank you for your understanding. I tried the correct constraint syntax: Insert: ISNULL (From_Employee_Hash_File.EMPLOYEE_NUMBER) AND ISNULL (From_Employee_Hash_File.FIRST_NAME) AND ISN...

Thanks so much for your response. I removed the key of three fields and made empl#, first name, last name all keys, built the hash file, then set up my job to do the inserts and updates into the employee table. I viewed the data in the hash file before running the insert/update job and it looks okay...

My source is an Oracle view of employees and I need to insert/update employees into an Oracle table based on whether employee number, first name, last name exist in the Oracle table. I created an employee hash file with a key of employee_num : first_name : last_name because I need to do a look-up ba...

I need to insert employee records into an Oracle table. One of the columns is 'password'. I need to set the password to 'password' (all lowercase) upon insert, but also encrypt it by using an existing Java class developed in this office that encrypts passwords. I assume in my transform that will wri...

Unfortunately I inherited this position after the person doing it was fired. Sorry to have bothered everyone with such a basic question. Training is necessary and important to me, but not to those who set my deadline.

I'm new to DataStage and have what I think is a simple job to write, but I'm wondering if there are templates (examples) to get me started. My source is an Oracle view of employee info with 7 data columns - that's no problem - I have my stage set up and I can view the data. Next I need to check to s...

THANKS!!!!!