DSXchange

Hi, I have to FTP source files from remote server to Datastage Server(UNIX). I had a look at FTP stage(Enterprise and Plug in). But looks like they transfer data in file and not the actual file. I need the actual file. In other topics on the forum i have seen people build routines or shell scripts. ...

Hi i am trying to read from a sequential file and i am getting the below error. Sequential_File_0,0: Fatal Error: Virtual data set.; output of "Sequential_File_0": the record is too big to fit in a block; the length requested is: 327584, the max block length is: 131072. Do i need to change...

I found a solution. we can export the table definition created. open it in a text editor and find and replace with you want. this works. for example i changed the nullable option to 'yes' in the text file. then you re-import that file.

By default when you import a sequential file definition the "nullable" columun is set to "NO". I have 800 columns in my table. it is hard to change them manually. Is there a way to change the default setting to "Yes".

If you have documnation you can refer to parellel job dveloper's guide. appendix A (schemas ) for reference. a simple one looks like below

record(
col1: Int32;
col2:string;
col3:string[] // sql varchar equivalent is string[]
)

Thanks

Is there a way to count the no of times the delimiter repeats and pass that as a parameter. i am just guessing wildly.

Hi, I have to read a delimited file(,) with varying number of columns. Also turn the columns into multiple rows. EX: Input rec_time,Acc_time,Para_ID,Tower_ID Ouptput rec_time Acc_time Para_ID Tower_ID I can use a schema file as the no of columns vary but how do i connect the pivot stage without know...