DSXchange

is it possible to create a dummy column (not coming from input) in datastage and assign some value to it say 'z'

what etl stage should I use to create a dummy column and assign value to it.

Thanks
Mark

Can someone please tell me how datastage interprets the following.

link.col1 = 5
link.col1 = '5'
link.col1 = "5"

Thanks
Mark

Hi All,

I have incoming data as (800) 123-4561 and expected output is 8001234561
Can anyone please suggest me how do i accomplish this.

Thank
Mark

I did not find training topics specific to ASB pack (xml,mq series, java, web services). I called 1800 426 8322 (option 1). waiting to hear from them (so far 48 hours and waiting....)

Thanks
Mark

Hi All,

Anyone know if IBM provides traininig in DataStage ASB Packs (such as XML Pack 2.0, Java Pack 2.0, and Web Services Pack 2.0)

Thanks
Mark

Hi All, The datastage jobs are aborting which used to run successfully before. the director log has these error messages Contents of phantom output file DataStage Job 53 Phantom 8488 readSocket() returned 16 DataStage Phantom Finished. can anyone please let me know how do I fix this error. Thanks Mark

I was able to locate the classpath. when I compile the java program it is giving me errors such as
package com.ascentialsoftware.jds does not exist

can someone please suggest me.

Thanks
Mark

Hi All,

I am working on a etl job using java pack. I have test.java program that I wrote. Can someone please tell me know how do I compile this program
into .class
where do I find the java classpath on etl server v8.1.

Thanks
mark

Is there any unix (AWK) solution available.

Please advice

Thanks
Mark

Hi All,

How do I get rid of embedded double quotes and single quotes in the data.

Incoming data: ' '"WASH BAy" SATIN' '

output data: 'WASH BAy SATIN'

Thanks
Mark

The job design looks like; sequential file stage --> column import --> copy stage --> other stages The input file is read in a single variable in sequential file stage. The column import regenerates other columns based on schema file. currently there are 20 columns in the schema file in column gener...

I removed the Prefixes in any schema file and it worked.

Thanks all for your suggestions.

Thanks
Mark

just for testing mode, I kept the number of columns in the schema file as fixed. (20 columns) then I run the job and I get the message Short Input Record. It also gives me a mesg, column import,0 Import was unsuccessful at record 0; The job completed successfully but it is not giving me the expected...

the job design looks like this;

seq stage ---> column import ---> seq stage

Now the job completes successfully, but all the records are getting rejected from column import stage.

error message:
Column_Import,0: Short input record

Thanks
Mark

I am readng the entire file in 1 column: "columnA" I have a column Import stage: Stage properties: Input: Import input column: ColumnA output: column method: schema file schema file: /xx/xx/schema_xxx options: keep import column = false reject mode: output output tab / mapping tab: No colu...