DSXchange

IBM replied that by design the parameter set content is exposed to the hierachical data stage. That is, even if the hierarchical stage does not make use of the parameter set value. Therefore, if a param set value has a special xml-json character in it, it has to be escaped otherwise and error will o...

Hi,

Problem seems to be related in using the hierachical data stage with a job using a parameter set value that has a single quote in it.

Running the same job with the same parameter set value without the hierarchical data stage is running fine with no error. Issue reported to IBM.

Hi, New project deploy to production environnement and while running sanity tests; the jobs using the Assembly Editor of the Hierarchical stage are failing with the following message in Director : Operator initialization: Input port 0 already connected; text: Hierarchical_Data_Tax: Operator initiali...

Hi Andy,

No. We haven't used this option in other jobs. We will open a ticket.

Thanks.

1) Errors: [11/21/18 13:28:31:476 EST] 000000d3 ServletWrappe I com.ibm.ws.webcontainer.servlet.ServletWrapper init SRVE0242I: [isclite] [/ibm/console] [/secure/tiles/contextScopeTile.jsp]: Initialization successful. [11/21/18 13:28:31:514 EST] 000000d3 ServletWrappe I com.ibm.ws.webcontainer.servle...

Hi, When using the Hierarchical Data stage Assembly Editor, in the Document Root tab, I am getting kicked out of the Assembly Editor when I try to set "Rec Xml" parsing to "Recursive To List". It displays the following error message: CDIUI2601E An unrecoverable error has occurred...

One thing to remember is that you wont get any gain of performance on anything that involves small files. Hadoop file system (HDFS) is not working well with small files. A small file can be defined as any file that is much smaller than the Hadoop block size. The Hadoop block size is usually set to 6...

Bonjour Thomas,

Yes you are right; cant do that with the Modify stage. I implement it as per your suggestion and it is working fine. I am getting the quotes only on the string columns but the column order is changed in the output sequential file. I will look at it.

Thanks.

Bonjour Thomas, You are right. What I am now looking at is to verify if I could add surrounding quotes to column using the Modify stage. If that is working then I am planning to do the following: -first produced a DS dataset; then using a shell script, parse the output of the orchadmin describe comm...

Hi,

I did resolved the warning issue by simply replacing the DB2 UDB connector by the oldest version of DB2 UDB API one.

Hi chulett,

Columns are not specified in the Sequential File target stage. We are using RCP.

Bonjour Thomas, Here is the output generated by OSH_PRINT_SCHEMAS: main_program: Schemas: Data set "users_rwd_test:Ln_Out_PADB_rwd.v": record ( indiv_id: nullable decimal[10,0]; rwd_prod_clm_seq: nullable int16; item_conf_no_bookg: nullable string[max=32]; ) Operator "rwd_file": ...

Hi, I am trying to generate a sequential file that will be used by a load command targeting DB2. The job is using RCP. The structure of my test table is decimal not null, smallint not null, varchar(32) not null with no default. Our sequential file format is : Record: final delimiter=end record delim...

Hi, We are using a server job that reads data using a hashfile and two plug-in; one is DB2 reading a dashDB (IBM Bluemix) database and the other using the ODBC stage reading a Paraccel database. We are receiving the following warning: "The connector does not support data transfer in Unicode for...

Hi,

Does changing the value of APT_STRING_PADCHAR from 0X0 to 0X20 is dynamic or will we need to recompile all of our jobs after to have them pick up the change?

Thanks.