DSXchange

karthi_gana

I also want to eliminate the header count from the file. how?

karthi_gana

No file size function and no line count function, but trivial to add to the program sample and even easier using the UNIX function "wc". FileSize(InputFilePath) Ans = '' ;** returned ...[/quote] I am not a premium member. can you post your code once again? I have seen the below forum http...

karthi_gana

No, but you could write your own in DataStage: FileEmpty(InputFilePath) Ans = '' ;** returned if file size couldn'b be determined OPENSEQ FilePath TO WorkFilePtr THEN R ...[/quote] I am unable to see the complete code. can you post it once again?[/quote] is there any function available to get the f...

karthi_gana

ArndW wrote:No, but you could write your own in DataStage:

FileEmpty(InputFilePath)
Code: Select all
   Ans = '' ;** returned if file size couldn'b be determined
   OPENSEQ FilePath TO WorkFilePtr
   THEN
      R ...[/quote]

I am unable to see the complete code. can you post it once again?

karthi_gana

All,

is there any pre defined function available to check whether a file is a zero-byte file or not?

karthi_gana

ray.wurlod wrote:Nothing is different. The job will process zero rows. ...

I just want to insert a row into a table with 0

karthi_gana

All,

How to process Zero byte length file(s) in datastage 7.5 ?

karthi_gana

I ran the batch for more than 5 time. I received the same error message. Didn't ask you to rerun the dang thing 5 times but rather Reset the aborted job and look for the log message I noted. :? I resolved KBA issue. After that i am facing the below error message. Batch::MJC_RSS_Exceptions..JobContr...

karthi_gana

Sounds like KBA stuff but that's not nearly enough information for anyone to help. Reset the aborted job and post any 'From previous run...' message that gets logged. ... I ran the batch for more than 5 time. I received the same error message. I am not aware of KDA stuff... can you explain it ?

karthi_gana

chulett wrote:Sounds like KBA stuff but that's not nearly enough information for anyone to help. Reset the aborted job and post any 'From previous run...' message that gets logged. ...

I ran the batch for more than 5 time. I received the same error message.

karthi_gana

Hi All, I have created a batch which in turn call a job. the job will copy data from DB2 to Sybase. It is a very simple job. when i execute the batch, it is going to 'Aborted' state immediately. I have checked the .ini file job hirearchy file. It is stored in the correct location. error : Attempting...

karthi_gana

All,

is this email id working now?

is this a group ?

shall i send emails to this id?

karthi_gana

I am unable to find the pdf file. Can you give me the URL ?

karthi_gana

chulett wrote: 2. They don't really need to be 'kept' anywhere. I suspect you're referring to the 'DataStage Engine'.

Yes...i just want to know about 'DataStage Engine'.

karthi_gana

Sure sounds like a (poorly worded) interview question to me. To what 'intermediate results' do you refer? 1) where the Hash File content will be stored? 2) If we create a constraint to reject the rows (say form example if id is null), datastage need some place to kept all the rows to apply constrai...

DSXchange

Search found 719 matches

function to check zero byte file

Processing Zero Byte File

Batch error - Attempting to Cleanup after ABORT raised

DataStage Users@Oliver.com