Search found 5168 matches

by kumar_s
Mon Mar 27, 2006 9:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple source files single ETL
Replies: 33
Views: 8463

Hi Anu, You can create a multiple instance job. Since all the files are with same formate, you can call the job 4 times in the job sequence with 4 different parameters as mentioned. Or you can concatinate all the files in the single stage by using cat filename_#_* Or you can use the property of file...
by kumar_s
Mon Mar 27, 2006 9:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Decimal to integer
Replies: 15
Views: 4464

Are you using transformer or BasicTransformer?
by kumar_s
Mon Mar 27, 2006 8:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Row count in Dataset
Replies: 9
Views: 4008

Yes this is the odd way of deleting it. But get deleted.
Try to give permission as 775 to all the file available under the datastage installation.
by kumar_s
Mon Mar 27, 2006 5:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Row count in Dataset
Replies: 9
Views: 4008

Have you tried with dsadm?
It is not necessary for datastage to use the same aproach we use to access the dataset.
by kumar_s
Mon Mar 27, 2006 5:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unknown client library
Replies: 16
Views: 4151

Just do a recheck, whether you have all these parameter initialized in the administrator.
By any chance you have different version of client installaion in that particular machine (which doesnt retreive the value from the server)?
At the worst, try to uninstall and reinstall the client softwares.
by kumar_s
Mon Mar 27, 2006 5:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple source files single ETL
Replies: 33
Views: 8463

wc -l will return number of lines in the file. In addition, the filename along with that.
awk '{ print $1 }' is use just to retreive the number alone.
by kumar_s
Mon Mar 27, 2006 5:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Row count in Dataset
Replies: 9
Views: 4008

Basically it should work.
What is the user id you use?
Try with dsadm. If that works, issue is sure with the permissions.
by kumar_s
Mon Mar 27, 2006 4:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unknown client library
Replies: 16
Views: 4151

I hope there is no mistake made, by loging in different project which has $PROJDEF undeclared or wrongly declared?
Have you tried with the suggestion of Arnd, by substituting the value of $PROJDEF and tried to view the data?
by kumar_s
Mon Mar 27, 2006 4:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Row count in Dataset
Replies: 9
Views: 4008

Have you check with the permission of those files.
by kumar_s
Mon Mar 27, 2006 4:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unknown client library
Replies: 16
Views: 4151

Hi Murali, DS Designer, Administrator, manager, Director are client windows. If you use designer to view a data by opening a input (sequential) stage and click on view data, it is ment that you are view from the client. It may be true that the server has been installed on the same machine you work. ...
by kumar_s
Mon Mar 27, 2006 3:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Row count in Dataset
Replies: 9
Views: 4008

Make sure your .profile have the following. DSHOME=/opt/Ascential/DataStage/DSEngine; export DSHOME PATH=$PATH:$APT_ORCHHOME/bin:$DSHOME/bin:$DSHOME/lib; export PATH . $DSHOME/dsenv LIBPATH=$APT_ORCHHOME/lib:$LIBPATH; export LIBPATH If not, add it. Exit. Open a new session, and try.
by kumar_s
Mon Mar 27, 2006 3:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage PX job aborted
Replies: 8
Views: 5409

The section leader process is responsible for coordinating the player processes that execute each stage and communication progress and messages to the coordinator process. Hence there should be one section leader per job pernode. Hence number of job (inturns number of stages) triggered parallely at ...
by kumar_s
Mon Mar 27, 2006 3:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple source files single ETL
Replies: 33
Views: 8463

Have you checked the previous post?
You can use the following to strip out header and trailer.

Code: Select all

head -$(expr $(wc -l filename | awk '{ print $1 }') \- 1) filename | tail +2
by kumar_s
Mon Mar 27, 2006 3:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage PX job aborted
Replies: 8
Views: 5409

It may be due to sudden surge of load on server.
Try to execute each job with a pause or a gap. 'sleep n' can be to maintain the pace.
by kumar_s
Mon Mar 27, 2006 3:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple source files single ETL
Replies: 33
Views: 8463

how to remove first row from top, i am not able to get the exact command to use in the filter command of seq stage, head -1 gives header line, i want all lines, but header how to go abt? thx Use tail +2 file name. to remove the first line. Pls read the previous post for removing trailer.