DSXchange

Hi Guys,

Can someone please help me about mvs version of datastage, i am unable to use ODBC in my mvs datastage, if i use dclgen for table definations will that help me in extracting the data and writing the data into the tables,

thanks in anticipation.

regards
Prashant

keshav0307 wrote:try Field(%string%,%delimiter%,%occurrence%,[%number%]) function

thanks keshav for ur reply...

actually it is not the number it always starts with after # # this data.

thanks

keshav0307 wrote:try Field(%string%,%delimiter%,%occurrence%,[%number%]) function

thanks keshav for ur reply...

actually it is not the number it always starts with after # # this data.

thanks

Hi Guys. I am working on mainframes and looking to split the colum info into two parts as i get the data like #kkkkkkkk# 19,trdgar place, USA i need to seperate the field with address in one column and the other part in # # be in another columns... and they are not fixed width. Any help is much appr...

Hi Guyz,

Can someone advise me of training on IBM Mainframe Jobs on Ascential datastage. Please advise me of any locations anything in India or Uk would be of great help.

Thanks
Kumar

Hi Guys,

I am not sure if i can post it here or not,,but can someone pls let me know where can i found the info abt the mainframes job development,and is it very tough when compare to other normal jobs as i am ok with server and parallel jobs,,

Thanks
Prashant

Hi,

Can someone help me in stopping and starting the datastage engine from client system on windows.

Regards
Prashant

ArndW wrote:Convert your dataset to VarChar(40) and trim your strings. ...

thanks Arndw,

with varchar(40) it is working but i was just wondering why it is not working with char(40) is there any particular reason why its not working

Hi... Can you explain about your job design..... thanks for the prompt reply. My design is database --------> dataset1 char(40) Trim Char(40) prash(data) COLname Order database --------> dataset2 varchar(40) varChar(40) prash(data) Colname order1 lets say my condition is if (order1<>order) then 0 e...

Hi Guru's, I am pretty much new to datastage, currently i am experiencing a probs where in my source datatype is char(40) when i trim this column and use for comparing with other varchar column which holds the same data as this, it is reading the columns as seperate data eventhough they have same va...

hi,,, thanks for all the help you guys were giving to me,, can someone pls help me out in using the job sequence,,,i need to run the jobs using the job sequencer in PX,,,i havent got clue abt it,,can someone pls help me with this,,i tried to read thru the px guide and tried the things,,cudnt achieve...

hi, everytime the transaction of any of these products go thru it will create a respective code prashant Who creates those codes. Do you create them? Well regardless, let them be there, pass them through a transformer and put the constraint not equal to those two codes. THANKS GURU IT DID WORK

hi, i am having big probs with this data,i get a flat file with a data on product codes,like soapcode,pastecode,transactioncode,drinkscode,winecode and so on..everytime the transaction of any of these products go thru it will create a respective code,,but i dont need winecode and pastecode, beside t...

kcbland wrote:If the rows are in a table, you're going to have to group and merge into a single row using SQL. Or, if it's in a file, you're going to have to use an Aggregation step to merge the rows. ...

THANKS FOR UR reply...

hi guys,

i am working with a credit card details,,i get the data in 4 rows, with one as amount, cardnumber, cv2 number and a filller record,,i need to read this as a single row so that it can show as single transaction,
help in this is very much appreciated..

thanks in anticipation