DSXchange

Hi Ray,

We have gone through Data set management utility and the segments it is showing is '0'.

We tried keeping '/' but same error we are getting.

That too sometimes it is working and sometimes it is not working.

Can you please give some inputs to solve this.

Hi,

Will it be a problem if we use Append mode.

Could you please through some inputs to solve this.

yes it should be in Append mode

Hi,

Even we tried with hash partitioning but the same thing is happening.

Can you please share if there is a possible solution to fix this.

Hi, Actually multiple jobs in a sequence job is using the same (.ds) file and the file is being appended, we are using the default partitioning method(Auto). All the way we are using execution mode as Prallel in all the jobs. Will it get solved if we change the option to Sequential in all the jobs. ...

Hi All, While i am trying to appending the same dataset from different jobs i am getting the following warning although the job is running fine.Could any one elaborate on this warning. main_program: Dataset: /detld2/etl/GPA/WM/log//Exception_613.ds, expecting 1 segments, read 2 segments. Your help w...

I have tried the way which you have suggested. In first link, i have taken update action is: LOAD . Records are not loading into the target table for longtime(still running). almost 40 mins for 4000 records. Same records are loading in a minute time if i give update action like:UPSERT. What might be...

Hi, Arrangement_id and Recency_id are there in target table. Arrangement_Id is key column to that table and is populating from source table. Recency_Id is Populating with 0 by hardcoding it in transformer stage.Now Recency_Id is updating with (recency_Id+1) where Arrangement_id=0. Two server jobs ar...

Hi,

while i am inserting into the SQL database,data is not loading completly for onecolumn. last character is missing in the table column,column length is correctly mentioned. please help whether i want to download some patches ,if so how?

Thanks in advance.

Hi, Thanks for your quick response. Now i can able to see the data because "Account_Number" column is of datalength 10 only, previously it was 12 thats is the reason datastage looking for double quotes in second field. It is probably trying to find double quote character (34 is the ascii v...

While viewing the sequential file in parallel job: "No rows were returned from the viewData sever command. Would you like to see the commands output? when i clicked yes I got a message like: "Bad trailing quote character at field "Account_Number"; looking for '34' but found '1', ...

Use this command, wc -l * |awk '{print $1}' Thanks I am trying to use the following in my Start Loop activity 'To' value : wc -l <filename> | cut -f"1" -d" " I have start value : 1, Step/Increment : 1 basically to go looping till the last record in the file. But it gives error sa...

Use this command, wc -l * |awk '{print $1}' Thanks I am trying to use the following in my Start Loop activity 'To' value : wc -l <filename> | cut -f"1" -d" " I have start value : 1, Step/Increment : 1 basically to go looping till the last record in the file. But it gives error sa...

Hi, While I bulk load around 2 million records to an Oracle table, I have seen duplicate data, that violates the primary key, going into the table and the primary key itself gets disabled. I am told that DS is diabling the PK, loading the data and then trying to enable it. Is anyone aware of an issu...

I am calculating this value in the Stage Varibale as 1/<col val>
e.g <col val> is 3 then I will calc 1/3 and expect to save 0.333333..
24 times.
Will casting still help?