DSXchange

Hi All, I am reading a text file from Windows Server and writing to a Unix Box using FTP Enterprise Stage. I am getting following error. Can any one let me know what is the problem. I appreciate your help and time. main_program: Data set, file set, or file "Transformer_6:DSLink7.v": Non-pi...

Hi Ray, When i changed the query to Auto Generated. It is working fine. Again i changed the query to user defined. Then also it is working. But i didn't know the exact reason why it is working now not earlier. Anyway i appreciate your time and patience. Yes, but the error message is now precise abou...

Hi Ray, Thanks for your response. After setting the APT_DISABLE_COMBINATION to True. Still i am getting the same FATAL Error message. But the job status in Director is showing as "Finished(See Log)". I appreciate your time and any help in this regard. Start by setting APT_DISABLE_COMBINATI...

Hi All, I am deleting records from a sql server table using ODBC Enterprise stage. I have written the following user defined sql Delete from stk where fsid <= orchestrate.fsacid. The datatype of the fsid & fsacid is smallint. This is the first time i am using ODBC Enterprise stage. I am getting ...

I figured it out. Thanks for your time

keshav0307 wrote:sorry the varibale value shoukd be

Sprev=(If LOC<>'' Then LOC Else Sprev)

Hi All, I struck up doing a job here. I have a data file in the following format. LOC DEPT STOCK 10, 1, 10 , 2, 20 , 3, 15 , 4, 15 20, 5, 10 , 8, 15 , 12, 12 30, 25, 15 , 30, 15 I have to assign the LOC '10' to the 2nd,3rd,4th records and LOC '20' to the next two records and 30 to the next record. C...

Hi

If you parameterize the invocation id and then use that parameter in defining the output file name then I think you can get it.

Thanks.

Hi

you have to execute this job serially . I think you got 5 rows because the server may be having 5 partitioned. So in the input link of Aggregator stage set the Execution mode as sequential .Hope that works for you.
Thanks.

Hi

Thanks for the information. It helps.

But I am concerned about the Buildops especially .For Buildops can I do create the scemas for the input and output table definitions dynamically ???

Thanks.

HI <Chains xmlns="http://www.w3schools.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.w3schools.com C:\CR\Chains.xsd"> In your xml file please do specify the schema location like below and give a try. <Chains xmlns="http:/...

Hi

I have a question like is it possible to create Buildops with Dynamic Schemas with out specifying the input table definitions and output table definitions at the time of design and it will pickup the schema definitions at run time ?

Thanks.

Hi I tried it to import that file and it is failing saying that main_program: Fatal Error: unknown block format [datamgr/datamgr.C:759] There are some decimal fields in it and I am getting like main_program: Fatal Error: Not a v1.1 type: decimal[4,0] [api/schema/schema.C:3869] and also I am getting ...

Hi Even I did also got same type of file with record size 160446 bytes. So I wonder will there be any problem while importing such kind of file or will there be any environment variable I need to include while importing. If suppose any body has the information please share with us. I appreciate your...

StuM wrote:Thanks again - use of %year_cutoffyy achieved the desired result.

Could anyone tell me how this works. I am using %2000yy. What theoretically will happen in 2100?

Thanks in advance.
StuM

I think it works same. The behaviour will not change.

Rgds
Lotus

My extract file is the variable length file with two different cobol layouts. I have to choose the layout depends on the REC_TYPE column. File is in the binary format. I have no idea how I could achieve this in the Data stage. Any help is greatly appreciated. One option is ask your source to send t...