DSXchange

Hi, My scenario here is that I have to automate my server job and it should pickup the file name dynamically. The file name comes from the source suffixed with the current date, i.e., xxx20050201.txt and next day it will be xxx20050202.txt I need help in passing this file name as a parameter so that...

Hi,

Kiran, I am still not able to abort my job, if the file is empty. Can u explain, how u acheived this using a shell script?

Probably, it might help me in doing the same.

Thx.

Hi All: My source file has 1 header, n detail and 1 trailer records. First I perform a check on the header, if the header is not found, I abort the job after 1 record in the constraint. I need to do the same with the trailer. I reject the trailer in a separate sequencial file, here if the trailer is...

Hi...

Is there anybody out there....who is familiar with the DS Extract Pack for SAP BW....

Hi All: I have a job that extracts data from an infospoke in BW. And I am using the BW Extract Pack to do this. I have given the process chain Name and the infospoke name from where I want to extract the data. The issues I encounter are - 1. When I run the job, it triggers the BW Process chain, whic...

I am not a Unix person....so hardly understood any of this.....

But the other method suggested by Ray did work.

Thank you Kim and Ray.

Thank you Ray.

The method suggested by you did work.

I was able to rename the file by separating the date in a separate file and concatenating it in the sh.

Hi All: I have a sequencer job as - Job Activity ---> Execute Command Job Activity runs a job with a source file which has a date field in the Header record. Execute Command runs a shell script to rename this source file with current date time stamp. Example: Input File Name: SourceFile.dat Output F...

Hi All: I have a sequencer job as - Job Activity ---> Execute Command Job Activity runs a job with a source file which has a date field in the Header record. Execute Command runs a shell script to rename this source file with current date time stamp. Example: Input File Name: SourceFile.dat Output F...

Hi,

If your format of output date is YYYYMMDD, this one works

DateGenericToTimeStamp(SourceLink)[1,8]

This converts to a Time stamp and you can just pickup the date.

I am not sure if this is the right way to do it. But it works.

Hi All: I have a variable length positional input file, upon which I use the CFF(Complex Flat File Stage) and separate the like records in different files. So now I have a Header file which has only one record. 8 sequencial files with different record types in it. And one Trailer/footer file with on...

IF there is anyone who knows anything about the CFF(Complex Flat File Stage)....!

Please HELP....!!!

Thx.

Hi All: I am reading a variable length file with the CFF stage. Each time the file comes from the middleware it has different number of records. Now in the CFF Stage-->Output tab-->Selection Criteria tab are given 2 options - 1. Start Record #......End Record # 2. Redefined Fields--> ID Field....Val...

Hi All: Thanks a lot for the previous responces.... :D I have another worry now. Have to use the CFF(Complex Flat File) Stage for one of my jobs. But have no clue about it. Tried searching in the online doc of datastage, but couldn't find much. Can anyone please provide me with some input regarding ...

Thanks All. I did try outputting header and trailer to a hash file and then output all required fields from the detail and hash files to a seq file. But the header and trailer fields do not get populated. Hence I tried using stage variables and call them in the end seq file, but still the header and...