Search found 38 matches

by mdtauseefhussain
Thu Oct 05, 2006 8:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Splitting a Large text file into small files
Replies: 13
Views: 5472

Thanks ,Sorry that script actually ,i wrote the script in notepad and svae it as shell scritp and tried to run ,the script was throwing error "cannot find Ctrl M the i tried to open that script in vi editor when i loked M cahracter was appearing in place of enter keys ,i deleted thos in vi edit...
by mdtauseefhussain
Thu Oct 05, 2006 7:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Splitting a Large text file into small files
Replies: 13
Views: 5472

the script is working when i run the commans individually

Wen i run it as a shell script it giving an error
by mdtauseefhussain
Wed Oct 04, 2006 10:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Splitting a Large text file into small files
Replies: 13
Views: 5472

Yes i ahve done that by using cat command i was able to achieve the desired results now iam thinking to automate the process ,as it is difficult to keep renaming the file As per the reuire ments i got a text file of size 62 mb i use split -10000 filename.txt Sample the result was 100 different files...
by mdtauseefhussain
Tue Oct 03, 2006 10:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Splitting a Large text file into small files
Replies: 13
Views: 5472

I have used the slpit command,it is Splitting the file ,but the output files are in different format but not in .txt format.

can anyone help me on this
by mdtauseefhussain
Tue Oct 03, 2006 10:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Splitting a Large text file into small files
Replies: 13
Views: 5472

Splitting a Large text file into small files

HI! all I have a text file which contains 90,000 records.my requirement is to split this file in to four parts becuse according to an requirement a file should contain 25,000 records only .After splitting i need to concatenate the timestamp with the file name , Plese can any 1 help me Thanks in Adva...
by mdtauseefhussain
Mon Sep 11, 2006 1:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom Erorr
Replies: 3
Views: 1243

Phantom Erorr

HI! All I have a job sequence which rund two jobs ,first job has finshed properly but it has thrown a warning and the sequence is aborted .the error message which iam getting is "start problems DataStage Job 192 Phantom 3072 DataStage Phantom Finished" This is the only error message iam ge...
by mdtauseefhussain
Mon Aug 21, 2006 3:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installing Parallel extender
Replies: 2
Views: 834

Installing Parallel extender

I am trying to install windows parallel extender server on Windows 2000 server ,but iam getting the following error

"This job is not runnable on this platform /operating system"

Can anyone help me in resolving this issue

Thanks in Advance
by mdtauseefhussain
Fri Jul 14, 2006 10:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Runnig a script in datastage
Replies: 17
Views: 4790

When i try this (date +"%Y-%m-%d %H:%M:%S") it is not working iam getting this error

" Output from command was: ***
mv: |11:01:39.txt not found
the jos is throwing warnings
by mdtauseefhussain
Fri Jul 14, 2006 7:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Runnig a script in datastage
Replies: 17
Views: 4790

Sorry guys iam very new to unix and datagstge ,please forgive me if iam asking silly questions
by mdtauseefhussain
Fri Jul 14, 2006 7:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Runnig a script in datastage
Replies: 17
Views: 4790

What if we want to bring the date format like this with file name

Sample 2006-07-14 22:25:30.txt
by mdtauseefhussain
Fri Jul 14, 2006 1:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Runnig a script in datastage
Replies: 17
Views: 4790

i tried with concatenating %h%m%s but iam getting the output as

"FileTestSort20060713Jul07%s" the time stam part is not coming properly
by mdtauseefhussain
Thu Jul 13, 2006 10:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Runnig a script in datastage
Replies: 17
Views: 4790

I need to concatenate time stamp along with the date the file name should be like this

Sample20060713000000
by mdtauseefhussain
Thu Jul 13, 2006 9:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Runnig a script in datastage
Replies: 17
Views: 4790

Runnig a script in datastage

I have a script for renaming the file ,when iam running the script in Unix command prompt it working fine,but when iam runing in Datastage After job subroutine on ExecSH it is throwing error The script is mv /data/datastage/Data/EMEA/sampleV.txt /data/datastage/Data/EMEA/sampleV$(date '+%Y%m%d')&quo...
by mdtauseefhussain
Wed Jul 12, 2006 8:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Concatenating Timestamp With a Sequential file
Replies: 33
Views: 11215

When i try to open the file iam getting this error "Encountered one error during transfer"
by mdtauseefhussain
Wed Jul 12, 2006 8:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Concatenating Timestamp With a Sequential file
Replies: 33
Views: 11215

HI!

iam able to create the file with the required file name but iam not able to open it