DSXchange

Well, I think if found the answer here http://pic.dhe.ibm.com/infocenter/iisinfsv/v8r7/index.jsp?topic=%2Fcom.ibm.swg.im.iis.ds.design.doc%2Ftopics%2Fr_ddesref_Server_Job_Properties_General_Page.html It mentions: "The release number n.N.n. This field is obsolete." Thus releasing a server j...

Hi there, This is a topic for the veterans :) I am currently doing a migration from 7.1 to 8.7 at a client side which relies pretty much on the "release a job" feature for versioning. I wonder if this functionality is still part of 8.x? Apparently we can import released jobs, but how can w...

We are running on RHEL 5 and IIS 8.1 FP1 and still have this issue.

I guess you cannot write records to a datasets which have bigger length than the blocksize of the dataset which is by default 128K. You can change that though by setting APT_PHYSICAL_DATASET_BLOCK_SIZE

No, there is now SAP Common Connector sofar. You need to extract the data first with DataStage then analyze. IA supports ODBC, TD and as far as I know also DB2 directly. ODBC has the capability to read text files. In future there are plans to add a dataset connector.

You do not need to fill the values using shell scripts if you leverage the new parameter sets. at run-time just specify the parameter set value file name. the parsing of the value file and setting the parameters will be done by datastage automatically then. the value file layout is pretty simple, ha...

so you are accessing TD without TPT? why that?
still add $OSH_PRINT_SCHEMAS to your job and set it to true, before running it. then check the job log for all the record schemas. btw n(var)char is also mapped to ustring.

so you are accessing TD without TPT? why that?
still add $OSH_PRINT_SCHEMAS to your job and set it to true, before running it. then check the job log for all the record schemas. btw n(var)char is also mapped to ustring.

mavrick21 wrote:Thanks for your replies.

tjr,
Could you please give me an example of parameterized commands?

Again thanks for your time.

the whole modify specification or parts of it can just be a job parameter that is resolved at run-time.

Is RCP enabled? If so and you read from a connector the type from the connector is propagated. Check with OSH_PRINT_SCHEMA all schemas at run-time.

Modify and transformer stages have comparable performance. The advantage of the modify stage clearly is that it fully supports RCP and parameterized commands. With it you can design much more generic jobs than just with the transformer stage.

ArndW wrote:Is it a pure binary format? Try reading it as "binary" into an integer. ...

Hey Arnd, it looks like you are very busy in Frankfurt

No.

In general you should never have nullable fields in expressions other then NullTo...(X) or IsNotNull(X) or IsNull(X), when they indeed can evaluate to NULL. It is much safer to write this expression: If IsNotNull(Trn_Track_Out_Dttm.MASK_SET_ID) AND Len(Trim(Trn_Track_Out_Dttm.MASK_SET_ID))>0 Then Tr...

SFTP is available in DS 8.0.1. What is the error you are getting?