DSXchange

chulett wrote:'Read' in what sense? If you are required to process them one by one, build a looping Sequence job. Otherwise, cat them all together (before job or in the Filter option) and 'read' them ...

i have to process them one by one and i need to know file name as well.
please advice

i have to read all file with file name from load directory.In each run number of file may vary.all files are fixed width length file. say for example below are my files in load directory( may be in next run i will have more files) 1_20100311_171556.txt 2_20100311_171556.txt 3_20100311-171556.txt 4_2...

chulett wrote:

asorrell wrote:Craig? Are you getting too old to chase tail?

My own tail, yes.

i need all this 9 DTL records in single column

<bzzzztttt> Sorry Andy, thanks for playing. :P D'oh... where the heck did Andy go? Silly Wabbit. Define 'not working', that looks perfectly fine to me. Are you sure you are checking the right 'column name'? Hi Chulett, its fixed length file ,and header ,details and trailer is there in one column on...

<bzzzztttt> Sorry Andy, thanks for playing. :P D'oh... where the heck did Andy go? Silly Wabbit. Define 'not working', that looks perfectly fine to me. Are you sure you are checking the right 'column name'? yah,problem is i have records in single column. which contain header ,details and trailer.

OK, simple enough, then just use a contraint to filter out any records where the first three characters in your big field are "HDR" or "TRL". ... Hi chulett, please advice me . i tried with dslink.column_name[1,3] <>'HDR' AND dslink.column_name[1,3] <>'TRL'. as constraint.but it...

Define your file metadata to match your "detail" records and the others will be filtered automagically, assuming their record layout is different enough to be rejected by the stage. ... Hi chulett, i dont have any metadata.i have records in single column. i am using sequential file as inp...

ArndW wrote:If you google the UNIX "sed" command, you'll see that changing the suggest command to

Code: Select all

sed '1,2d;$d' 

should do the trick. ...

my datastage server is in window..can i use unix command in this ?

you have to define that in the filter option of the sequential file stage. Hi HITMAN, actually i will have two columns first column= filen name,second column=records detail. i have to filter header and trailer from records column. in my records column sample data will look like given above. please ...

hitmanthesilentassasin wrote:try this in your filter option of either sequential file or cff.

Code: Select all

 sed '1d;$d' 

or

Code: Select all

 sed '/HDR/d; /TRL/d'

Hi Hitman,

Can you please help me out ,in sequential file where i can define sed '/HDR/d; /TRL/d' to remove header and trailer .Please advice

thanku

Hi,

I am not able to use SUBSTR(DSLink149.INTFC_FILE_CATG,1,4).it seems we don't have substring function in 8.1.
I have to take first 4 char of INTFC_FILE_CATG field in my transformer stage.
Please advice which function i can use to get first 4 char from a field .

Thanks
Kaushal

thanku

Hi,

While inserting data for CHAR data type field ,i am not able to trim the spaces .In Database i could able to see spaces.I tried with both TRIM and TrimLeadingTrailing functions. I am using SQL Server 2005 database as target. Please let me know how to resolve the issue.


Regards
Kaushal

i am using folder stage to read files from load directory . My files are fixed width length file .I am dfining column1 as file name and column 2nd as record( which suppose to contain records of file) . but in my job its taking only first rows of file.Please help me what i need to define so that it ...