A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.
Moderators: chulett , rschirm , roy
deepa_shenoy
Participant
Posts: 95 Joined: Thu Sep 24, 2009 12:15 am
Location: India
Post
by deepa_shenoy » Mon Nov 30, 2009 10:30 pm
Hi,
I want to load a Dataset Target File, but it always throws the warning XYZ.ds file empty.
In the first load it will be empty right? I have created an empty file in UNIX and given Update='Overwrite' in the Dataset.
I have three dataset files as target. The error is coming only for two .ds files. I am not able to catch the problem. Any idea why this is happening?
Thanks in advance.
Regards,
Deepa
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Mon Nov 30, 2009 10:32 pm
The ".ds" file must not exist if you want to create a new Data Set.
Why did you create it? On whose advice? (It was incorrect advice.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
deepa_shenoy
Participant
Posts: 95 Joined: Thu Sep 24, 2009 12:15 am
Location: India
Post
by deepa_shenoy » Mon Nov 30, 2009 10:55 pm
But if I am running the same job more than once, it will throw an error saying that the .ds file already exists. How do I give the option of Overwrite as well? The job will always be run twice (minimum).
muraliipc
Premium Member
Posts: 6 Joined: Mon Jul 27, 2009 7:45 pm
Location: Singapore
Contact:
Post
by muraliipc » Mon Nov 30, 2009 11:08 pm
Hi,
set update policy in dataset stage as overwrite
Thanks
vin..
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Mon Nov 30, 2009 11:29 pm
If a VALID ".ds" file exists then all will be well.
An empty ".ds" file is not valid.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
deepa_shenoy
Participant
Posts: 95 Joined: Thu Sep 24, 2009 12:15 am
Location: India
Post
by deepa_shenoy » Mon Nov 30, 2009 11:33 pm
Hmmm. Only for the first load it will be empty. After that for every other load it will have valid data. Any workaround possible?
Or
Load 1: Create file
Load 2 onwards: Overwrite
But it throws the warning only for 2 out of 3 ".ds" files.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Nov 30, 2009 11:43 pm
No, for the first load it will not exist so it will create it and then with the right setting overwrite it after that. No "workaround" needed.
As noted, stop pre-creating empty files.
-craig
"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Dec 01, 2009 3:46 am
Note also that the ".ds" file does not contain any data. Ever.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue Dec 01, 2009 6:21 am
Other than the 'meta' kind.
-craig
"You can never have too many knives" -- Logan Nine Fingers