DSXchange

You can do this by defining stage variables, sorting the data on the key column and concatenate the 2nd column

Hello, I am trying to list all the sequencer jobs that uses the FTP_EPSILON_HOST user defined environmental variable. I asked the Admin to run the below command but it did not list any sequecers even though we have many jobs. DS_JOBS WITH JOBTYPE = 2 AND EVAL "TRANS('DS_JOBOBJECTS','J\':@RECORD...

Hello,
Can you please let me know how I can list all the jobs that uses a certain environmental variable in a project.

Thanks

Hi, I am trying to access the IBM Bluemix cloud Biginsights (HDFS) files using Datastage 11.5 - File connector stage(webhdfs) which is in on-prem computer. I have set up the biginsights in bluemix.But the connection is failing with the on-prem datastage application. I have brought the SSL certificat...

Can anyone please help me out on above request...Thanks in advance


-Sharath

I am trying to load data to Hive table using JDBC Connector stage. Connection is established and I am able to view the data from the table but when the insert statement is executed job is failing with the below error. MSG ID: <IIS-CONN-JDBC-00009> JDBC_Connector_14,1: Fatal Error: The connector fail...

Can anyone please help me out on this...It's urgent

Hi, I am getting below errors while trying to connect to HDFS through datastage using any stage like BDFS,HDFS File connector, File Connector. Error 1: main_program: Fatal Error: Failed to read data from Application Master sending YARN resource information. Check the health of YARN/Hadoop. Socket er...

stringtodate(DSLink9.DT,"%m/%d/%yyyy") this worked

Hello,
I am trying to convert 1/1/2014 to 2014-01-01. Any suggestions. I tried this but output to file has all ***

DatetoString(stringtodate(DSLink9.DT,"%mm/%dd/%yyyy"),"%yyyy-%mm-%dd")

Thanks

I have tired giving max buffer size = 12800. But still failing with same issue.

Thanks

Thanks for the reply. 1. Yes i am aware of the limitation on the bulk mode. 2. Yes i did use the APT_DEFAULT_TRANSPORT_BLOCK_SIZE ENV variable with default value 1280000 3. I also used APT_TSORT_STRESS_BLOCKSIZE with default value as 3000000 as per IBM link below. 4. The buffer side i tried using a)...

1. I am using Teradata connector stage 2. I am using immediate option with array size 1. bulk option is not working. 3. write mode: Insert 4. Table action: Append 5. Record count 100 6. Enable lob references: NO 7. The target column that i have issue is defined as clob. I am able to insert filed les...

I am able to load using bteq script in to the teradata table. so there is no issue on the DB side.

Thank you for the response.. Following is the error: TD_etl_unq,0: Field col contains a value that has a byte length of 91,456 which exceeds the allocated length of 64,000 (the field value is '{"ptyLocRtf":[{"actnCd":"I","locUsgId":"0","addrSeqN...