DSXchange

Hi ArndW

We have not tried testing the job. My colleague mentioned that if our insert failed, we need to rollback the data. And commit if the insert is successful.

Hi ArndW, I checked again and Write mEthod = Load, Write Mode = Append.
I dont know but the analyst said that we dont use Upsert on updating the table.

Hi Everyone, I like to ask for help on using Close Command on Oracle Enterprise Stage. What I need to do is to update a table using Close Command. We are not allowed to use UPSERT method because of large volume of data. So we are using Write Method = Load, Write Mode = Truncate. Can anyone point me ...

Hi, I need to fetch rows from an oracle enterprise stage, my mapping document looks something like this, select Table.ID Where( DATASET.COL1|| '_' ||DATASET.COL2|| '_' |||DATASET.COL3) = Table.UNQ_ID Is it possible to use the value coming from a dataset as a filter to my select statement.? Thanks.

Hi Priyadarshi,

Thank you for you explanation. That cleared my confusion. Thanks.

Hi Shane,

Ahm so once I converted it using StringToDate its ouput would be a date format right? But on my mapping document it needs the format to be yyyymmdd. Hmmm. Im so lost.

Hi, I have an input string (varchar) coming from a sequential file which looks like: yyyymmdd I want it on my output dataset to become sql type = date with same format yyyymmdd. Tried solution: 1. I tried using StringToDate("yyyymmdd", "%yyyy%mm%dd%") but on output viewdata it be...

Hi, Cant find anywhere else to ask for help. Hope someone can enlighten. We have a datastage sequence which we want to execute via shell script. The first job activity in that sequence is an FTP object writing to a sequential file. On datastage, that job is working fine, however, on the script, it i...

Write the new lines, and any required empty lines, to a dummy file. Then use TYPE command to append the log file. Then delete the log file, and rename the dummy file. The first of these steps is pr ... Hi , I cannot get any insight from your reply since I'm not a premium member. Job Pay is just eno...

Hi, I have a log file which registers rejected records and is being used by 3 separate jobs executed as follows: Job1>Overwrite Log File; Job2> Append Log File; Job3>Append Log File. The Log file looks something like this. Co11~Col2~Col3~Col4~Col5~Col6 0123456~132455~987654678~ADDRNUMBER~1234566~1 M...

This unix is so sensitive :3. What I did was declared:
OUT = $ (With space)
and there's the OUT not found error.

When I removed the spaces:
OUT=$
It finally echoed the correct message.


Thanks for all your Inputs. Clicking mark as resolved. :D

Hi. I tried setting OUT = $? , removing the double quotes on the $OUT in the if statements and running again but now I'm getting this output: Status Code = 0 Waiting for job... Finished Waiting for job Job Status : (1) Status Code = 1 aa.sh [36]: OUT: not found aa.sh [38]: test: 0403-004 Specify a p...

Hi. I have a simple source>join>target parallel job and when I run it on the Datastage it works fine, but when I run it using shell script it is returning errors. I'm currently on a much complex requirement where I should run 2 sequences using a shell script and trying my code on a smaller job befor...

Thank you for all your inputs. Now I dont have compile errors. What we did was remove the stage variable, add an additional transformer stage, create two new columns where the derivation we used was the one on the stage variable. and put the isnull and is not null into the constraint into the next t...

Hi, My requirement is to capture the 2 fields from deleted rows from an oracle database and put those 2 fields in a sequential file. I used Write Method = Delete Rows; User defined delete. Do i need to insert the sequential file before I perform the delete? Or is it that the output of the Oracle Dat...